Access denied for user root localhost using password Yes after password reset LINUX

Question

I have a MySQL installed on my linux server  I forgot it s password so I went and changed it using the methods I found on the web  What I did was as follows    etc init d mysql stop mysqld safe --skip-grant-tables  amp  mysql --user root mysql SELECT   FROM user     I checked if I could access the user table or not update user SET password   PASSWORD  new pass   WHERE user    root   flush privileges  exit   The update query did change the password as it showed me the number of rows affected and Query OK etc   Then I restarted mysql   etc init d mysql stop  etc init d mysql start   Now when I logged in with the new password   mysql -u root -p new pass   it still gives me errors   ERROR 1045  28000   Access denied for user  root   localhost   using password  Yes    Is there something that I am missing

User · Answer

You may need to clear the plugin column for your root account  On my fresh install  all of the root user accounts had unix socket set in the plugin column  This was causing the root sql account to be locked only to the root unix account  since only system root could login via socket   If you update user set plugin    where User  root  flush privileges   you should now be able to login to the root account from any localhost unix account  with a password    See this AskUbuntu question and answer for more details

User · Answer

On mac os  please follow below steps   Stop MySQL    sudo  usr local mysql support-files mysql server stop Start it in safe mode     sudo mysqld safe --skip-grant-tables  above line is the whole command   This will be an ongoing command until the process is finished so open another shell terminal window  log in without a password     mysql -u root  mysql  UPDATE mysql user SET Password PASSWORD  password   WHERE User  root   Start MySQL  sudo  usr local mysql support-files mysql server start your new password is  password

User · Answer

Actually I took a closer look at the user table in mysql database  turns out someone prior to me edited the ssl type field for user root to SSL   I edited that field and restarted mysql and it worked like a charm   Thanks

User · Answer

You have to reset the password  steps for mac osx tested and working  and ubuntu  Stop MySQL    sudo  usr local mysql support-files mysql server stop   Start it in safe mode     sudo mysqld safe --skip-grant-tables    above line is the whole command   This will be an ongoing command until the process is finished so open another shell terminal window  log in without a password     mysql -u root  mysql gt  UPDATE mysql user SET Password PASSWORD  password   WHERE User  root     Start MySQL  sudo  usr local mysql support-files mysql server start   your new password is  password

User · Answer

I meet the same problem   progrAmmar enlightened me   took a closer look at the user table in mysql database    My problem is not ssl type  instead of the first field Host  I changed the value by using   update user set Host  localhost  where User  root  and Host       in mysqld safe --skip-grant-tables model    Then it works well

User · Answer

You can try this solution  -  To have mysql asking you for a password  you also need to specify the -p-option   try with space between -p and password   mysql -u root -p new password   MySQLl access denied  In the Second link someone has commented the same problem

User · Answer

I was able to solve this problem by executing this statement  sudo dpkg-reconfigure mysql-server-5 5   Which will change the root password

User · Answer

Maybe the current user is not root try sudo mysql -uroot -p  I successed just now

User · Answer

In my case     etc init d mysql stop mysqld safe --skip-grant-tables  amp      in new window    mysql -u root mysql  use mysql  mysql  update user set authentication string password  password   where user  root   mysql flush privileges  mysql  quit  etc init d mysql restart

User · Answer

I had the same problem  You have to write mysql -u root -p  NOT mysql or mysql -u root -p root password

[mysql] Access denied for user 'root'@'localhost' (using password: Yes) after password reset LINUX

Examples related to mysql

Examples related to linux

Examples related to configuration