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

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