Bind remote Mysql user to Ip

[tawy]

Hello,

lets say that i have 2 servers one that has a database and the other that has a website that connects to this database


i enabled remote Mysql connection to the database on server1 for a user

the problem is that the user can access the database from any ip

i want it to access the database only from the server2 ip which has the site


Thanks

tawy Reviewed by tawy on 30th Aug 2011. Bind remote Mysql user to Ip Hello, lets say that i have 2 servers one that has a database and the other that has a website that connects to this database i enabled remote Mysql connection to the database on server1 for a user the problem is that the user can access the database from any ip i want it to access the database only from the server2 ip which has the site Rating: 5

[XSLTel]

Hello,

use firewall to drop all requests from other IPs and accept only from the IP of the server2.

Highest Regards
Mohammed H

[tawy]

but i want to bind this particular user to the server2 ip not the entire server connection


Thanks

[NewEraCracker]

Do you have any control panel installed?

[tawy]

Do you have any control panel installed?

Mysql server (Server1) is on windows server 2008 (no control panel)
Website server (Server2) is on linux (directadmin)

[tawy]

Nvm i found how to do it

on creating any database user there is 3 feilds

User:
Password:
Host:

by putting the ip of server2 in Host this binds this user to this ip thus it cannot be accessed from any other ip than provided

an easy way to do this is by using mysqlcc (Mysql control center) if you are using Windows server

Thanks

[Lock Down]

Very simple. Thanks for the update.