List:General Discussion« Previous MessageNext Message »
From:Erick Ocrospoma Date:January 13 2014 6:02pm
Subject:Re: Access denied for user 'root'@'localhost' (using password: YES)
on mysql admin
View as plain text  
I forgot this. Do it too.

On 13 January 2014 13:01, Erick Ocrospoma <zipper1790@stripped> wrote:
> I presume your index.php file uses "127.0.0.1". After login to MySQL try this:
>
> $> grant all privileges to *.* 'root'@'127.0.0.1' identified by
> <yourpassword>;
$> flush privileges;
>
> Of course this could not be the best solution, it's just to skip it,
> you must look at the query/connection on your php file.
>
> On 13 January 2014 12:57, Érico <ericomtx@stripped> wrote:
>> using localhost the coonection works ...
>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost
>> -P 3306
>> Enter password:
>> Reading table information for completion of table and column names
>> You can turn off this feature to get a quicker startup with -A
>>
>>
>> Welcome to the MySQL monitor.  Commands end with ; or \g.
>> Your MySQL connection id is 97
>>
>> Server version: 5.6.15 MySQL Community Server (GPL)
>>
>>
>> ........
>>
>> but using 127.0.0.1 no :
>>
>> ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h 127.0.0.1
>> -P 3306
>> Enter password:
>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>> password: YES)
>> ericomtxmacbookpro:bin ericomtx$
>>
>>
>>
>> 2014/1/13 Erick Ocrospoma <zipper1790@stripped>
>>>
>>> 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
>>>
>>> --
>>> MySQL General Mailing List
>>> For list archives: http://lists.mysql.com/mysql
>>> To unsubscribe:    http://lists.mysql.com/mysql
>>>
>>
>
>
>
> --
>
>
>
>
>
> ~ 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



-- 





~ 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