List:General Discussion« Previous MessageNext Message »
From:Érico Date:January 14 2014 7:04pm
Subject:Re: Access denied for user 'root'@'localhost' (using password: YES)
on mysql admin
View as plain text  
 yes it is ...

  also , the eclipse is also local ...

  in both ... mysql-admin php application , plus inside eclispe plugin ...

  same behavior in both


2014/1/13 Reindl Harald <h.reindl@stripped>

> i doubt that the webserver is running on the same
> machine as your mysql command shell
>
> Am 13.01.2014 23:59, schrieb Érico:
> > true
> >
> > but please check this out :
> >
> > mysql> Select user, host, password from mysql.user;
> >
> +------+--------------------------+-------------------------------------------+
> > | user | host                     | password
>      |
> >
> +------+--------------------------+-------------------------------------------+
> > | root | localhost                |
> *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > | root | ericomtxmacbookpro.local |
> *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > | root | 127.0.0.1                |
> *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> > | root | ::1                      |
>       |
> > |      | ericomtxmacbookpro.local |
> *E85DC00A0137C6171923BE35EDD809573FB3AB4F |
> >
> +------+--------------------------+-------------------------------------------+
> > 5 rows in set (0.00 sec)
> >
> > all passwords are filled in the db ...
> >
> > also ... I can connect through command line
> >
> > what I can't do is :
> > 1. connect or even ping inside eclipse using jconnector
> >
> > 2. connect from a php app (mysql adim) with or with out pwd ...
> > providing the error
> >
> >
> >   Access denied for user 'root'@'localhost' (using password: YES)
> >
> >
> >   Access denied for user 'root'@'localhost' (using password: NO)
> >
> >
> > 2.1 when I use 127.0.0.1 on mysql admin url ... I get a connection closed
> >
> > so ... my point is :
> >
> > in both cases .... when using 127.0.0.1 or localhost ...
> >
> > can the OS be blocking the connection ?
> >
> > if so , how could I check this ?
> >
> > Regards
> > Érico
> >
> >
> > 2014/1/13 Reindl Harald <h.reindl@stripped <mailto:
> h.reindl@stripped>>
> >
> >     WTF - we are talking about *database connections* and *not*
> http-URL's
> >     the webserver is only the *messenger*
> >
> >     Am 13.01.2014 18:54, schrieb Érico:
> >     > using both urls I get the same error :
> >     >
> >     > http://localhost/mysql/index.php
> >     > http://127.0.0.1/mysql/index.php
> >     >
> >     > in 127.0.0.1... after I submit the index.php ... it redirects to
> localhost
> >     > too ..
> >     >
> >     > 2014/1/13 Reindl Harald <h.reindl@stripped <mailto:
> h.reindl@stripped>>
> >     >
> >     >>
> >     >>
> >     >> 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 <mailto:root@stripped> =
> different users
> >     >>
> >     >> localhost: Unix-Socket
> >     >> 127.0.0.1 <http://127.0.0.1>: TCP
> >
> >
>
> --
>
> Reindl Harald
> the lounge interactive design GmbH
> A-1060 Vienna, Hofmühlgasse 17
> CTO / CISO / Software-Development
> m: +43 (676) 40 221 40, p: +43 (1) 595 3999 33
> icq: 154546673, http://www.thelounge.net/
>
> http://www.thelounge.net/signature.asc.what.htm
>
>

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