well, i am mysql administrator over 10 years now and never needed the "mysqladmin" command because the mysql command line client offers anything i ever needed
mysql -u root -p [harry@srv-rhsoft:~]$ mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 16056 Server version: 5.5.37-MariaDB-log thelounge Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> Am 29.05.2014 21:19, schrieb Érico: > 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
signature.asc
Description: OpenPGP digital signature
