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

no connections outside command line are being accepted . I have connected
through command line , but not using eclipse for example ... it gets the
same error from the web app

my apache and pages are in the same computer that mysql

I am not getting password issues.. otherwise I would not connect through
command line

Thks


2014/1/13 shawn l.green <shawn.l.green@stripped>

> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

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