Connecting to MySQL REMOTELY

Hi,

I'm trying to connect to a remote MySQL DB using software like MYSQL Control Center, etc.

When I enter the details that I would use to connect "locally", I can't connect.

The program gives me the followin error:

[CI] ERROR 1045: Access denied for user: 'USERNAME@XXX.XXX.XXX.XX' (Using password: YES)

Can anybody tell me what I should do...

I created the a user that has access to the DB, I set the "host" field to '%', which I thought meant that user can get in from "anywhere".

Thanks!

Did you flush the privileges or restart the MySQL database after you added the user ?

To flush the privileges you can execute the query:

FLUSH PRIVILEGES

Hi There,

Just tried FLUSH PRIVILEGES, didnt' help. Any more suggestions out there?

THanks!

Hi,

can you post the code ? It might be a problem of how you called mysql_connect but I need to view the code 🙂

You may need to do this to be able to connect from somewhere other than the localhost:

In mysql command line while logged in as root type this:

mysql> use mysql;
mysql> UPDATE user SET Host="%" WHERE user="root";

Where root is whatever user you want to connect remotly with.
Be sure to restart the mysql service afterwards.