Restricting MySQL Access from Command Line

Normally I use webmin to do this, but i am having a problem with the User Permissions section of the webmin MySQL module.

What I want to do is restrict access to a MySQL database so the user can only come from a certain IP address. I tried the following command:

Code: 
mysql> insert into db
  -> (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
  ->        Create_priv,Drop_priv)
  ->       values  ('ipaddress','dbname','username','Y','Y','Y','Y','Y','Y');
However, I get a 1064 error when I do that. Do you all have any idea what they right command is?

Thanks!

 

 

 

 

Top