Unable to connect to phpmyadmin(WAMP)

[nvidia]

Hi,

 

  i downloaded WAMP a while ago and i've been using the MYSQL console to connect and run my sql quries and create my tables ect. I know want to be able to use PHPMyAdmin to do all of this. So i clicked phpmyadmin and i saw the following error:

 

Error

MySQL said: 

 

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

 

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

 

Now, i've been looking over the internet for solutions, but i've noticed that people are responding to these types of post referring to phpmyadmin as a standalone program and are therefore referring to different config files that are not in WAMP or are called differently.

 

So, please can somebody tell me exactly how i can configure my WAMP to allow me to use phpmyadmin.

 

p.s Please only reply with WAMP specific answers rather than answers assuming that i have a standalone phpmyadmin application because i do not as it does not help me.

 

Thanks

[Mchl]

Did you change root password for MySQL?

phpMyAdmin installed with WampServer is configured to connect to MySQL with no password. If you set up a password for root, you need to modify config.inc.php file in c:\wamp\apps\phpmyadmin3.x.x.x\

[nvidia]

Yes hi,

 

  i did actaully change the root password at the mysql prompt thing, but i did not change it on the file you spoke off. After i found it and added my password, saved it and it worked straight away.

 

Thanks a bunch

[teamatomic]

As you like to use phpmyadmin for db management take a look at SQLbuddy. Besides all  that phpmyadmin can do it will also let you create/manage db users. Once I started using it I have not used phpmyadmin at all.

http://www.sqlbuddy.com/

 

 

HTH

Teamatomic

[Mchl]

As you like to use phpmyadmin for db management take a look at SQLbuddy. Besides all  that phpmyadmin can do it will also let you create/manage db users.

 

Like phpMyAdmin does?