#1045 – Access denied for user ‘root’@’localhost’ (using password: YES)

by

I first changed the root password running mysql at a prompt with

mysql -u root -p

Update password:

UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User="root";

Edited line in the file config.inc.php with the new root password:

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

Stop and re-start mysql service (in Windows: mysql_stop.bat/mysql_start.bat)

and got phpMyAdmin to work!

EDIT 2017: for MySQL≥5.7 use authentication_string in place of Password (see this answer):

`UPDATE mysql.user SET authentication_string=PASSWORD('MyNewPass') WHERE User="root";

`

More Related Contents:

  1. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  2. where does MySQL store database files?
  3. If two columns are 1 then make new column
  4. #1071 – Specified key was too long; max key length is 1000 bytes
  5. MySQL : isn’t in GROUP BY
  6. MySQL: Can’t create table (errno: 150)
  7. Restore table structure from frm and ibd files
  8. What is maximum query size for mysql?
  9. phpMyAdmin on MySQL 8.0 [duplicate]
  10. Setting up foreign keys in phpMyAdmin?
  11. Access localhost from the internet [closed]
  12. Can’t connect to MySQL server on ‘localhost’ (10061)
  13. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  14. How to change the default port of mysql from 3306 to 3360
  15. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  16. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  17. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  18. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  19. phpMyAdmin is throwing a #2002 cannot log in to the mysql server phpmyadmin
  20. How to Import Multiple csv files into a MySQL Database
  21. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  22. How to turn on/off MySQL strict mode in localhost (xampp)?
  23. Can’t import database through phpmyadmin file size too large
  24. Access denied after setting user’s password with SHA256 in phpMyAdmin
  25. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  26. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  27. How do I write an SP in phpMyAdmin (MySQL)?
  28. How to get back Lost phpMyAdmin Password, XAMPP
  29. UTF8 problem with MySQL 5
  30. mySQL query to search all tables within a database for a string?

Leave a Comment