Skip navigation links

MySQL Forums :: Security :: Restrict access to the database to allowed IPs only.


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. 16221 ken well 08/06/2007 05:54AM
Re: Restrict access to the database to allowed IPs only. 19641 Ryan Lowe 08/06/2007 08:13AM
Re: Restrict access to the database to allowed IPs only. 7966 Thy Scorpion 12/11/2007 05:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.