Hi no connections outside command line are being accepted . I have connected through command line , but not using eclipse for example ... it gets the same error from the web app
my apache and pages are in the same computer that mysql I am not getting password issues.. otherwise I would not connect through command line Thks 2014/1/13 shawn l.green <shawn.l.gr...@oracle.com> > Hello Érico, > > > On 1/13/2014 1:49 PM, Érico wrote: > >> Hi >> >> didn't work >> >> look ... isn't this something related to this : >> >> 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 >> >> ... >> >> since I am not able to stabilsh a connection even with using eclipse ... >> >> my /etc/hosts file : >> >> ## >> 127.0.0.1 localhost >> 255.255.255.255 broadcasthost >> ::1 localhost >> #fe80::1%lo0 localhost >> 127.0.0.1 ericomtxmacbookpro.local >> #127.0.0.1 mysqld >> >> > The thing to remember is that 'localhost' or '127.0.0.1' is where the > server believes the connection is coming from. The password you must be > using in your client connection attempt must match the one used on the > server for the mysql user 'root'@'localhost' or you will not authenticate. > > You also need to remember that if your .php page is on a different > machine, it is not connecting to the same mysqld that you have running in > your development machine (your personal environment). Your .PHP page is > trying to connect to the one running on its host machine. That user 'root' > may have an entirely different password. > > Your programs are connecting fine. If they didn't you would get a > different message. They are failing to authenticate which means that the > mysqld they are connecting to does not recognize the password you are using > for the account you are trying to authenticate as. > > Regards, > -- > Shawn Green > MySQL Senior Principal Technical Support Engineer > Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. > Office: Blountville, TN > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > >
