running this : ./mysqladmin -u root -p
at this momento it thorws me to mysqladmin man page 2014-05-29 15:35 GMT-03:00 Reindl Harald <h.rei...@thelounge.net>: > > Am 29.05.2014 20:22, schrieb Érico: > > 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') > > your command line is plain wrong > as you can see in the response you are *not* using a password > > ./mysqladmin -u root --password=<pwd> > > *don't do that at all* your password ends in the history > ./mysqladmin -u root -p > > after that you get a pwd-prompt > > > how can I restore the db so I can connect through command line again ? > > if you really need to login with a destroyed userdb make sure > that nobody else can access the server and use skip grant > > > http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables > >
