nvidia Posted February 8, 2010 Share Posted February 8, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/191410-unable-to-connect-to-phpmyadminwamp/ Share on other sites More sharing options...
Mchl Posted February 8, 2010 Share Posted February 8, 2010 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\ Quote Link to comment https://forums.phpfreaks.com/topic/191410-unable-to-connect-to-phpmyadminwamp/#findComment-1009064 Share on other sites More sharing options...
nvidia Posted February 8, 2010 Author Share Posted February 8, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/191410-unable-to-connect-to-phpmyadminwamp/#findComment-1009106 Share on other sites More sharing options...
teamatomic Posted February 8, 2010 Share Posted February 8, 2010 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 Quote Link to comment https://forums.phpfreaks.com/topic/191410-unable-to-connect-to-phpmyadminwamp/#findComment-1009170 Share on other sites More sharing options...
Mchl Posted February 9, 2010 Share Posted February 9, 2010 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? Quote Link to comment https://forums.phpfreaks.com/topic/191410-unable-to-connect-to-phpmyadminwamp/#findComment-1009292 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.