WampServer

I'm new to PhpmyAdmin

I am trying to set the password - here are the steps I took.

1. I typed in 'Root' and hit enter ( no password was need)
2. I clicked the change password ( a mix of 1 uppercase ,1 lowercase and a set of numbers)
3. I Received an error - couldn't change password error 1133
4. I went to C:\wamp\apps\phpmyadmin4.0.4\config.inc.php

changed
$cfg['Servers'][$i]['AllowNoPassword'] = true; to false
$cfg['Servers'][$i]['auth_type'] = 'cookie'; to config

ran it again and didn't work so I changed back
5. went to comd prompt accessed MySQLadmin and tried to change it from there - didn't work
C:\wamp\bin\mysql\mysql5.6.12\bin -- the address


Nothing has worked does anyone have a solution

OK, I assume you are using WAMPServer 2.4

Undo all the changes you made and then repeat steps 1. and 2. but use 'root' as the username ( all lower case ).

So error 1133 means 'there is no username of Root so I cannot change its password'.

Its a little odd I admit, but the login screen allows you to enter any Username/Password pair and if the one you use does not exist it still throws the phpMyAdmin home page, but you have no privilages to do anything.

I wasn't able to log in I got #1045 cannot log into the MySQL server

I went onto the phpmyadmin site and in the login typed 'root' -all lower case

and received that error

You could try

uninstalling WAMP
Delete the C:\wamp folder and all subfolders

Reinstall WAMP

And try again.

I have installed wamp 2.2. everything is green a good to go. I have tested php and it works well; however, when I try to go to phpMyAdmin, I get error 404 and a complaint about not have the right password. I did not get a prompt for a user name or password. What now?

mds

The way phpMyAdmin is configured changed between WampServer 2.2 and 2.4, the above info was for WampServer 2.4.


In WampServer 2.2 it should just launch into phpmyadmin and work, until you try to chnage the password.

What have you changed,
Have you restored any mysql databases?