Recommended Servers for MySQLThe world's most popular open source database
MySQL Forums
Re: Restrict access to the database to allowed IPs only.
Posted by: Ryan Lowe ()
Date: August 06, 2007 08:13AM
That is implied in the GRANT statement:
GRANT SELECT ON databasename.* TO 'username'@'hostname' ... ;
(where hostname can be a literal FQDN or an IP address or something with a wildcard).
Be sure to remove any users from mysql.user where hostname is not specified (or is a %) if you wish to lock down the database.
GRANT SELECT ON databasename.* TO 'username'@'hostname' ... ;
(where hostname can be a literal FQDN or an IP address or something with a wildcard).
Be sure to remove any users from mysql.user where hostname is not specified (or is a %) if you wish to lock down the database.
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Restrict access to the database to allowed IPs only. | 5163 | ken well | 08/06/2007 05:54AM |
| Re: Restrict access to the database to allowed IPs only. | 4965 | Ryan Lowe | 08/06/2007 08:13AM |
| Re: Restrict access to the database to allowed IPs only. | 2713 | Thy Scorpion | 12/11/2007 05:52AM |
Sorry, you can't reply to this topic. It has been closed.