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 <kish...@railsfactory.org>:
> 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 <erico...@gmail.com> 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
>>
>
>
