List:General Discussion« Previous MessageNext Message »
From:shawn l.green Date:May 29 2014 10:34pm
Subject:Re: access denied fpr user 'root'@'localhost' (using password: NO)
View as plain text  
Hello Érico,

On 5/29/2014 3:51 PM, Érico wrote:
> 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 !!
> ... snip ...

What is the result of this query:

SELECT user, host, length(password) from mysql.user;

What hapens if you change your login to this? (you should not put your 
passwords on your command lines if you can avoid it
http://dev.mysql.com/doc/refman/5.6/en/password-security-user.html
http://dev.mysql.com/doc/refman/5.6/en/connecting.html
)

./mysql -h 127.0.01 --port=3306 --protocol=TCP -u root -p mysql-admin

See also:
http://dev.mysql.com/doc/refman/5.6/en/access-denied.html

-- 
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
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