Connecting to a MySQL server from a different domain

Currently I have my settings set up this way;


host = "localhost";
username = "wf_weir"
password = "XXXXX"
db_name = "db_name"

and it works.

However I'd like to connect to this same database from another domain.

The IP is 207.210.84.76 so what settings would I use to connect to this database?

 

Just host=207.210.84.76

You'll also need to ensure that the IP of the other domain has permission to access the server with your database on (this will be set on the database server).

 

Thats what I thought but it's not letting me do that.

How would I check to see if the IP of the other domain has permission?

 

In the server with the database, you will need to open port 3306.

You will have to log into PHPMyAdmin and change the user permissions. Instead of being able to connect by localhost only, you will set it to %, which means they can connect from anywhere.

PS - This is just some info I saved when trying to connect to one databse from two domains.

 

Silly question : How do I open port 3306 from the server with the database?

 

In the firewall rules.

 

Do you have cPanel on the db server?

 

Yes I do dct!

Where are the firewall rules?

 

ok I just figured out how to put the % for any access host

but...

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client


Does this mean the other server has their 3306 port blocked?

 

In cPanel go to the databases section and at the bottom of the screen you should see where to add access for other hosts.

I haven't got access at the moment so can't give specific instructions.

 

No that means you get a warning because you're using an old mysql client on the remote client.

It's only a warning so it might work anyway.

 

Nothing loaded up after that message so it isn't going to work. Thanks for all the help though guys. Appreciate it!

 

I'm having the same problem but I don't have cPanel because I'm using helm. I seem can't find how to open the port 3306.

 

I have the same problem, I did the steps above and now i have this message:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Anyone know how to fix it?