Guys, I'm trying to connect my MySQ

[Stingreen]

Guys, I'm trying to connect my MySQL server from outer internet via "MySQL Control Center" which I downloaded from mysql.com. Now the problem is when I try to connect to the database it turnes an error saying,

ERROR 1130: Host 'xx.xx.xx.xx' is not allowed to connect to this MySQL server.

Now, how can I allow this host to connect to mysql server anytime ? Matter of fact, I want all IP based hosts to be allowed..
How do I do this ?
Thanks in advance.

 

[sleipnir214]

MySQL user credentials consist of a 3-tuple: username, password, and allowed login IP address.

In the IP-address part of the credentials, a wildcard is available, "%", which can replace any trailing part of an IP address of hostname. For more information, please point your browser to

http://www.mysql.com/doc/en/GRANT.html

That being said, I recommend judicious use of the wildcard. I is a good policy to limit access whereever possible, and locking down subnets can be a good "security in depth" mechanism when used with a firewall. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[sleipnir214]

Correct. I say "any trailing part of". Strike the word "trailing". Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!