List:General Discussion« Previous MessageNext Message »
From:Érico Date:May 29 2014 7:51pm
Subject:Re: access denied fpr user 'root'@'localhost' (using password: NO)
View as plain text  
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.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
> 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.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
> >>
> >>
> >>
> http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables
>
>

Thread
access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
  • Re: access denied fpr user 'root'@'localhost' (using password: NO)Reindl Harald29 May 2014
    • Re: access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
      • Re: access denied fpr user 'root'@'localhost' (using password: NO)Reindl Harald29 May 2014
        • Re: access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
          • Re: access denied fpr user 'root'@'localhost' (using password: NO)shawn l.green29 May 2014
  • Re: access denied fpr user 'root'@'localhost' (using password: NO)Kishore Vaishnav29 May 2014
    • Re: access denied fpr user 'root'@'localhost' (using password: NO)Érico29 May 2014
  • Re: access denied fpr user 'root'@'localhost' (using password: NO)shawn l.green29 May 2014