Sample Header Ad - 728x90

"Access Denied user root error code 1045 (28000)" after changing root passwords

1 vote
0 answers
47 views
I'm encountering an "Access Denied user root error code 1045 (28000)" error with user root. I'm facing this problem after changing passwords. It was working fine before, and I'm confused about where I might be making a mistake. I changed the password for root on localhost, but it's not working in one specific condition. The server starts working only when I use the following commands: systemctl stop mysql mkdir /var/run/mysqld chown mysql /var/run/mysqld mysqld_safe --skip-grant-tables & After that, I just type mysql -u root and hit Enter, and the server starts working. However, when I close Putty, it stops working, and I encounter the error "1045 (28000)" again.
Asked by Mushtaq Ahmad (11 rep)
Sep 14, 2023, 06:42 AM
Last activity: Sep 14, 2023, 07:12 AM