downloaded the wamp server on several different occasions. I was having trouble opeing the localhost browser as well as creating a new connection in Navicat, so I went on navicat's live chat support. I was able to open the phpadmin page before I went to the support chat, but the tech guy had me type a command line in the SQL window of phpadmin....something about GRANT USER PRIVILEGES command line. Now I cant even open phpadmin page. It gives me the 1045 access denied for user root@localhost error message. Please someone tell me whats going on!!
You need to grant the privileges to the user you are using to access the Mysql server. For example, the user is root and the password is 123456, you need to goto the Mysql prompt and execute the following command: This will grant all the privileges to root user and you will be able to access the databases via phpMyAdmin.