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>; 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
