I am really sorry about this one ..
the connection is ok ...
I had not checked that I was using mysqladmin instead of mysql
now please how can I check what is wrong with my application ( My SQL Admin
at its login page it asks for user / pwd / server and db
using both localhost and 127.0.01 ... it gets the same error :
access denied for user 'root'@'localhost' ....
the app has a php config page where it fills these info
I am able to connect to it manually too using :
./mysql -h localhost -u root -p<my_pwd> mysql-admin
but the app keeps geting the access denied error
would it be sometihng related to my /et/hosts ?
its content :
my SO is a mac os 10.6.8
Thks Again !!
2014-05-29 16:26 GMT-03:00 Reindl Harald <h.reindl@stripped>:
> 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
> 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.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