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 : 127.0.0.1 localhost 255.255.255.255 broadcasthost ::1 localhost fe80::1%lo0 localhost 127.0.0.1 mysqld 127.0.0.1 mac localhost mac my SO is a mac os 10.6.8 Thks Again !! 2014-05-29 16:26 GMT-03:00 Reindl Harald <h.rei...@thelounge.net>: > 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 > >
