List:General Discussion« Previous MessageNext Message »
From:shawn l.green Date:January 13 2014 7:17pm
Subject:Re: Access denied for user 'root'@'localhost' (using password: YES)
on mysql admin
View as plain text  
Hello Érico,

On 1/13/2014 1:49 PM, Érico wrote:
> Hi
>
> didn't work
>
> look ... isn't this something related to this :
>
> are you using "localhost" or "127.0.0.1" in the web-application
> root@localhost != root@stripped = different users
>
> localhost: Unix-Socket
> 127.0.0.1: TCP
>
> ...
>
> since I am not able to stabilsh a connection even with using eclipse ...
>
> my /etc/hosts file :
>
> ##
> 127.0.0.1       localhost
> 255.255.255.255 broadcasthost
> ::1             localhost
> #fe80::1%lo0    localhost
> 127.0.0.1       ericomtxmacbookpro.local
> #127.0.0.1       mysqld
>

The thing to remember is that 'localhost' or '127.0.0.1' is where the 
server believes the connection is coming from. The password you must be 
using in your client connection attempt must match the one used on the 
server for the mysql user 'root'@'localhost' or you will not authenticate.

You also need to remember that if your .php page is on a different 
machine, it is not connecting to the same mysqld that you have running 
in your development machine (your personal environment). Your .PHP page 
is trying to connect to the one running on its host machine. That user 
'root' may have an entirely different password.

Your programs are connecting fine. If they didn't you would get a 
different message. They are failing to authenticate which means that the 
mysqld they are connecting to does not recognize the password you are 
using for the account you are trying to authenticate as.

Regards,
-- 
Shawn Green
MySQL Senior Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
Thread
Access denied for user 'root'@'localhost' (using password: YES) onmysql adminÉrico13 Jan 2014
  • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminReindl Harald13 Jan 2014
    • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminErick Ocrospoma13 Jan 2014
      • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico13 Jan 2014
        • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminErick Ocrospoma13 Jan 2014
          • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminErick Ocrospoma13 Jan 2014
            • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico13 Jan 2014
              • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminErick Ocrospoma13 Jan 2014
                • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico13 Jan 2014
                  • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminshawn l.green13 Jan 2014
                    • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico13 Jan 2014
                      • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminReindl Harald13 Jan 2014
                        • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminshawn l.green13 Jan 2014
                          • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminReindl Harald13 Jan 2014
    • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico13 Jan 2014
      • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminReindl Harald13 Jan 2014
Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico14 Jan 2014
  • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminClaudio Nanni15 Jan 2014
    • Re: Access denied for user 'root'@'localhost' (using password: YES)on mysql adminÉrico16 Jan 2014