MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

by

I had this problem after changing the password for the root user in phpMyAdmin. I know nothing about programming but I solved it by doing the following:

  1. Go to file C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php (I guess you would replace “wamp” with the name of your server if you’re not using Wamp Server)

  2. Find the line $cfg['Servers'][$i]['password']='' and change this to

    $cfg['Servers'][$i]['password']='NO'

  3. Try opening phpMyAdmin again, and hopefully the message will now read “Access denied for user ‘root’@’localhost’ (using password: YES)

  4. Now change the password in the above line to ‘yourpassword‘ (whatever you had set it to before)

Hope this helps somebody.

More Related Contents:

  1. How to get back Lost phpMyAdmin Password, XAMPP
  2. If two columns are 1 then make new column
  3. #1071 – Specified key was too long; max key length is 1000 bytes
  4. MySQL : isn’t in GROUP BY
  5. MySQL: Can’t create table (errno: 150)
  6. xampp MySQL does not start
  7. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  8. Setting up foreign keys in phpMyAdmin?
  9. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  10. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  11. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  12. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  13. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  14. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  15. access denied for load data infile in MySQL
  16. Where to change the value of lower_case_table_names=2 in XAMPP on Windows?
  17. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  18. How to Import Multiple csv files into a MySQL Database
  19. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  20. How to turn on/off MySQL strict mode in localhost (xampp)?
  21. Can’t import database through phpmyadmin file size too large
  22. Access denied after setting user’s password with SHA256 in phpMyAdmin
  23. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  24. XAMPP – Error: MySQL shutdown unexpectedly
  25. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  26. How do I write an SP in phpMyAdmin (MySQL)?
  27. How to import large sql file in phpmyadmin
  28. Import CSV to Update rows in table
  29. UTF8 problem with MySQL 5
  30. mySQL query to search all tables within a database for a string?

Leave a Comment