List:General Discussion« Previous MessageNext Message »
From:Erick Ocrospoma Date:January 13 2014 6:01pm
Subject:Re: Access denied for user 'root'@'localhost' (using password: YES)
on mysql admin
View as plain text  
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>;

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
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