Home / Questions /Q 1330
Next
In Process
sita
sita

sita

  • India
View Profile
  • 0
Asked: 2021-02-03T12:37:15+05:30 In:

sql error access denied for user ‘root’@’localhost’ Fix

  • 0

when i tried to run the following Sql command “$ ./mysqladmin -u root -p ‘”
it is showing “sql error access denied for user ‘root’@’localhost'”. How can i fix $ ./mysqladmin -u root -p ‘ ?

mysqladmin: connect to server at ‘localhost’ failed error:
mysqlerror access denied for user rootlocalhost using password yes

how to fix sql error access denied for user 'root'@'localhost'sqlsql errorsql error access denied for user 'root'@'localhost'sql error access denied for user 'root'@'localhost' how to fixsql error access denied for user 'root'@'localhost' how to solvesql local host error
Share

    Related Questions

    1 Answer

    1. chandra_tech

      chandra_tech

      • India
      View Profile

      To fix the “error access denied for user ‘root’@’localhost’ ” we need to check and verify the root password.

      root@localhost access denied errors need to reset of root password.Please do follow the below steps to solve :

      1.stop mysql

      /etc/init.d/mysql stop

      2.start mysql safe :

      mysqld_safe

      3.connect to mysql

      mysql -u root

      4.change the password

      mysql> use mysql;
mysql> update user set password=PASSWORD(”YOUR_PASSWORD”) where user=’root’;
mysql> flush privileges;
mysql> quit

      5.stop mysql

      /etc/init.d/mysql stop

      6.start mysql

      /etc/init.d/mysql start

Now you can able to login successfully with the new password.
      • 1
    Leave an answer

    Leave an answer

    Browse