Granting mysql access rights to all machines on subnet

mysql security database-permissions subnet
epeleg picture epeleg · Jun 19, 2011 · Viewed 16.6k times · Source

I have a mysql instance (and schema) running on windows that I can access via a connection string based on localhost as the server.

now I want to be able to access this db from another machine on the same subnet.

If possible I would like to use a single user but allow it to access from any machine on the same subnet.

how do I setup security for this? (I already opened the relevant firewall port)

Thanks, Eyal

Answer

BugFinder picture BugFinder · Jun 19, 2011

You can do it like this:

GRANT ALL PRIVILEGES ON mydb TO 'username'@'192.168.1.0/255.255.255.0';

change subnet and IP accordingly

Related questions

How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More
SQL injection that gets around mysql_real_escape_string()

Is there an SQL injection possibility even when using mysql_real_escape_string() function? Consider this sample situation. SQL is constructed in PHP like this: $login = mysql_real_escape_string(GetFromPost('login')); $password = mysql_real_escape_string(GetFromPost('password')); $sql = "…

Read More
How to secure phpMyAdmin

I have noticed that there are strange requests to my website trying to find phpmyadmin, like /phpmyadmin/ /pma/ etc. Now I have installed PMA on Ubuntu via apt and would like to access it via webaddress different from /phpmyadmin/. What …

Read More