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 <zipper1...@gmail.com> > 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.rei...@thelounge.net> 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@127.0.0.1 = 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 > >
