when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do for this
+1
A:
Your client IP is not allowed to connect to this server, you must add it to allowed client account For exemple, assuming you add an user account having all rights in one database :
grant all on db.* to 'username'@'192.168.0.1';
Where db is database name, username the username , and your clients IP is 192.168.0.1
See docs for details of user account creation
Benoit
2010-05-18 13:07:02
whr i have to add this
ratty
2010-05-18 13:08:49
this is SQL query to run on server with an account with enough privileges to do grant queries on the table
Benoit
2010-05-18 14:10:25