• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

mysql connection from external host

W

w0uter

Guest
Hi,

I want that a external website can make a connection whit my mysql server. I want this because both websites (on different servers) are using the same database. Can someone tell me how i can fix that the other website can make a connection whit my musql server ?

Greets Wouter
 
In a shell, do this:

$ mysql -u admin -p

[enter admin password]

mysql > grant all on database_name.* to 'remote_user'@'remote_ip' identified by 'remote_user_password';
mysql > flush privileges;
mysql > \q

Et voilá!

Notes:

* refers to "all tables", if you want to give permission for just one table, use database_name.table_name.

"all" can be any specific permission (select, etc..), so you may grant select only to that external IP if you wish.

If you wish to grant access to any external IP, substitute remote_ip with %.
 
Back
Top