I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma <zipper1...@gmail.com> wrote: > 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>; $> flush privileges; > > 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 <erico...@gmail.com> 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 <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 >>> >> > > > > -- > > > > > > ~ 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
-- ~ 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
