Pages

Tuesday, July 12, 2011

Mysql - Giving Permissions to an IP Address to access the Database

How to give permissions to an IP Address to access
a table in Mysql Database ?

Type the following query in the mysql prompt.

mysql -u root -p

 GRANT SELECT,INSERT,UPDATE,
-> DELETE,CREATE,DROP
-> ON Database / *.* / Database.Tablename
-> TO 'useraccount@IPAddress'
-> IDENTIFIED BY 'Password';
 
I found the following link to be useful, for beginners.
 
http://www.developer.com/java/data/jdbc-and-mysql-installation-and-preparation-of-mysql.html 
http://www.roseindia.net/jdbc/jdbc-mysql/MysqlConnect.shtml 
http://www.kitebird.com/articles/jdbc.html
 

No comments:

Post a Comment