List:General Discussion« Previous MessageNext Message »
From:Érico Date:May 29 2014 6:22pm
Subject:access denied fpr user 'root'@'localhost' (using password: NO)
View as plain text  
I have ran the following to test a fix for an app issue :

delete from mysql.user where user='';
2lines got effected

after this I can´t connect through command line anymore :

./mysqladmin -u root password <pwd>

I get access denied for user 'root'@'localhost" (using password:'NO')

how can I restore the db so I can connect through command line again ?

thks

Thread
access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
  • Re: access denied fpr user 'root'@'localhost' (using password: NO)Reindl Harald29 May 2014
    • Re: access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
      • Re: access denied fpr user 'root'@'localhost' (using password: NO)Reindl Harald29 May 2014
        • Re: access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
          • Re: access denied fpr user 'root'@'localhost' (using password: NO)shawn l.green29 May 2014
  • Re: access denied fpr user 'root'@'localhost' (using password: NO)Kishore Vaishnav29 May 2014
    • Re: access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
  • Re: access denied fpr user 'root'@'localhost' (using password: NO)shawn l.green29 May 2014