List:General Discussion« Previous MessageNext Message »
From:Erick Ocrospoma Date:January 13 2014 5:47pm
Subject:Re: Access denied for user 'root'@'localhost' (using password: YES)
on mysql admin
View as plain text  
From that error I would suspect you are trying to access to a database
where has not external access. And yeah, try by doing

$> mysql -u root -p <database> -h localhost -P 3306

change localhost by 127.0.0.1 in order to test if both cases work, and
see which of them (localhost/127.0.0.1) is defined in your web app as
you've been told in the mail before.

On 13 January 2014 12:36, Reindl Harald <h.reindl@stripped> wrote:
>
>
> Am 13.01.2014 18:28, schrieb Érico:
>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin
>> Enter password:
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 31
>> Server version: 5.6.15 MySQL Community Server (GPL)>
>>
>> but in the browser I get the error :
>>
>> Access denied for user 'root'@'localhost' (using password: YES)
>>
>> I can't find any information in error log and access log
>>
>> is there any command parameter that I should use when starting mysql so
>> this doesn't happen?
>
> 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
>
>
>



-- 





~ Happy install !



Erick.


---

Cellphone   :  +51 950307809
Blog    :  http://zerick.me/
LUG    :  http://www.utpinux.org
IRC     :   zerick
About :  http://about.me/zerick
Linux User ID :  549567
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