Skip navigation links

MySQL Forums


Advanced Search

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.

Options: ReplyQuote


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.