well, i am mysql administrator over 10 years now
and never needed the "mysqladmin" command because
the mysql command line client offers anything i
mysql -u root -p
[harry@srv-rhsoft:~]$ mysql -u root -p
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.
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.reindl@stripped>:
>> 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
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc