List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:January 13 2014 8:01pm
Subject:Re: Access denied for user 'root'@'localhost' (using password: YES)
on mysql admin
View as plain text  
*your application* is connecting to mysql
*your application* is using a hostname
*your application* *may* use 127.0.0.1
*your application* should use localhost to *connect to the databse*
*your application* can only use TCP *if there is* a *mysql user* with *that host*

http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html

Am 13.01.2014 20:38, schrieb Érico:
> 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
> 
> 2014/1/13 shawn l.green <shawn.l.green@stripped>
> 
>> 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.


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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