MySQL – ERROR 1045 – Access denied

by

If you actually have set a root password and you’ve just lost/forgotten it:

  1. Stop MySQL

  2. Restart it manually with the skip-grant-tables option: mysqld_safe --skip-grant-tables

  3. Now, open a new terminal window and run the MySQL client: mysql -u root

  4. Reset the root password manually with this MySQL command: UPDATE mysql.user SET Password=PASSWORD('password') WHERE User="root";
    If you are using MySQL 5.7 (check using mysql –version in the Terminal) then the command is: 

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

  5. Flush the privileges with this MySQL command: FLUSH PRIVILEGES;

From http://www.tech-faq.com/reset-mysql-password.shtml

(Maybe this isn’t what you need, Abs, but I figure it could be useful for people stumbling across this question in the future)

More Related Contents:

  1. How to change the mysql root password
  2. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  3. Can’t connect to MySQL server error 111 [closed]
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. How do I find the MySQL my.cnf location
  6. What data type to use for hashed password field and what length?
  7. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  8. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  9. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  10. brew install mysql on macOS
  11. How to reset mysql root password?
  12. Setting the MySQL root user password on OS X
  13. Access denied for user ‘root’@’localhost’ while attempting to grant privileges. How do I grant privileges?
  14. MySQL user DB does not have password columns – Installing MySQL on OSX
  15. Resetting ROOT password in MySQL 5.6
  16. mysql root password forgotten
  17. MySQL password function
  18. How to reset the root password in MySQL 8.0.11?
  19. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  20. access denied for load data infile in MySQL
  21. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  22. Bash script to insert values in MySQL
  23. Mysql permission errors with ‘load data’
  24. How to change MySQL table names in Linux server to be case insensitive?
  25. Commit data in a mysql container
  26. libmysqlclient15-dev on macs?
  27. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  28. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  29. Linux shell script for database backup
  30. How to get back Lost phpMyAdmin Password, XAMPP

Leave a Comment