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


Hello,

Mysql  server  error  ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)   . I am unable to resolve the issue .

thomasjoshua Supporter Asked on September 23, 2016 in Technology.
Add Comment
1 Answer(s)

Hello all,

[root@localhost]# service mysqld stop

[root@localhost]# sudo mysqld_safe –skip-grant-tables &

[root@localhost]#  mysql -uroot

[root@localhost]#  use mysql;

[root@localhost]# mysql -uroot

[root@localhost]# update user set password=PASSWORD(“REPLACEYOURPASSWORD”) where User=’root’;

[root@localhost]# flush privileges;

[root@localhost]# quit

[root@localhost]#  service mysqld restart

[root@localhost]# mysql -u root -p


Addisonjack Supporter Answered on October 1, 2016.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.