mysql connection from external host

[w0uter]

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

 

[superbock]

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 %.

 

[lvalics]

Or you can use PSA Power Toys to offer an external connection