How to change wamp phpmyadmin password?

What is causing MySQL error #1045?

• This is definitely one of the most frustrating error I've encounted. To my understanding, there are several components involved in database interaction. There is the MySQL database itself, and the phpMyAdmin. From various MAMP forum threads, I've established that I need to change the password inside the following files to solve this error: /Applications/MAMP/bin/phpMyAdmin/config.inc.php, /Applications/MAMP/bin/mamp/index.php, /Applications/MAMP/bin/http://stopMysql.sh I have also been told to change the password in the command line: /Applications/MAMP/Library/bin/mysqladmin -u root -p password [NEW PASSWORD] I have several questions actually: 1. There are many password changing activities happening here. What are the responsibilities of each file above really? 2. Is that password-changing command redundant with changing the password of any of the mentioned files (that are, config.inc.php, index.php, http://stopMysql.sh)? I have edited all of the three mentioned files to have the same username/password (root/root), but still has no luck changing the password on the command-line. Any ideas?

• Answer:

  See the documentation at http://dev.mysql.com/doc/refman/5.1/en/access-denied.html; I'd start by invoking mysql directly and confirming that you can access the DB with the username:password credentials you have set up. If not, confirm that the DB does, indeed, exist, then re-login as root, USE DB; GRANT ALL PERMISSIONS ON DB* TO 'username':@'localhost' IDENTIFIED BY 'password' and confirm that username:password with command line mysql and the various places in your PHP configuration. It's probably a good idea not to use root for the php username.