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.rei...@thelounge.net> > 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.rei...@thelounge.net <mailto: > h.rei...@thelounge.net>> > > > > 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.rei...@thelounge.net <mailto: > h.rei...@thelounge.net>> > > > > > >> > > >> > > >> 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@127.0.0.1 <mailto:root@127.0.0.1> = > 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 > >
