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' ,
2014-05-29 15:36 GMT-03:00 Kishore Vaishnav <kishore@stripped>:
> Did you tried this..
> *-- *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 ?