List:General Discussion« Previous MessageNext Message »
From:Érico Date:May 29 2014 7:01pm
Subject:Re: access denied fpr user 'root'@'localhost' (using password: NO)
View as plain text  
Hi

thanks but it is not working either

I wonder if the 2 rows I removed (with empty users for localhost and my
computer names) were responsilbe for allowing the autentication ?

how this table works ?

what mysql checks on it ? the pwd column ? if it is filled ?

what if I have 2 records for root/localhost ... ?

one with pwd filled
and the second with the pwd empty

how can I insert on this table with the mandatory column ssl_cipher as blob
... ? what value must I provide in a insert like :

insert into mysql.user(host,user,ssl_cipher) values('localhost','root' ,
??? )

thks !!


2014-05-29 15:36 GMT-03:00 Kishore Vaishnav <kishore@stripped>:

> Did you tried this..
> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
>
>
> *thanks,*
> *-- *Kishore Kumar Vaishnav
>
> On Thu, May 29, 2014 at 11:22 AM, Érico <ericomtx@stripped> wrote:
>
>> 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