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
