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 >
