_mysql_exceptions.OperationalError: (1045, “Access denied for user ‘root’@‘localhost’ (using password: YES)”)

on
ERPNext

To Resolve this issue. try

MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords:
1) Login to the MySQL server, type the following command at the shell prompt:
mysql -u root -p
2) Use the mysql database (type commands at the mysql> prompt):
mysql> use mysql;
3) Change password for a user:
MySQL 5.7.5 and earlier
mysql> update user set password=PASSWORD("newpass") where User='ENTER-USER-NAME-HERE';
MySQL 5.7.6 and newer
mysql> SET PASSWORD FOR 'ENTER-USER-NAME-HERE'@'localhost' = PASSWORD("newpass");
4) Reload privileges:
mysql> flush privileges;
mysql> quit

Community Forum: https://discuss.erpnext.com/
ERPNext Hosting

Comments

  1. Tawnya Spivey7 October 2024 at 06:01

    The error "_mysql_exceptions.OperationalError: (1045, 'Access denied for user 'root'@'localhost' (using password: YES)')" means MySQL is rejecting the 'root' user's credentials. Check your password or reset it, and ensure the user has the necessary privileges. If you're using LangFlow, confirm your database settings are correct.

    ReplyDelete

Post a Comment