Quick MySQL question...

[Jugernot]

I'm trying to connect to a remote MySQL server on our network and it am running into problems with authentication. I am used to connecting to a MySQL server on the localhost, so this remote stuff is perplexing me.

Basically when I plugin the info for the helpdesk app I'm setting up, I get the following error:

Warning: Access denied for user: 'root@XXXX.XXXXX.com' (Using password: YES)

Warning: MySQL Connection Failed: Access denied for user: 'root@XXXX.XXXXX.com(Using password: YES)

Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Warning: MySQL: A link to the server could not be established

Now, the XXXX.XXXXX.com is my local machine, NOT the MySQL server hostname. So I'm guessing, it's saying it doesn't recognize the root from another machine. Though I know for a fact other machines connect remotely to this SQL server...

Any ideas?

 

[bunker]

I don't know much about MySQL, but from those error msg's it looks like it's trying to connect to a local server and not the remote one.

 

[Ben]

I'm just learning MySQL myself but this might help you link

 

[Rias]

It's saying that you aren't allowed to connect from the host you're connecting from with the username and password you have provided.

You need to enable access on the remote mysql server by adding your username, encrypted password, and the host you'll be connecting from to the 'user' table on the remote mysql server and then reload the database server.