How to allow all remote hosts in MySQL

Avatar
Eric3712
  • Answered
Is it possible to configure MySQL to accept connections from all remote hosts. I have an extensive number of hosts that I need to authorize to access my database, and it would be easier if I could simply allow all connections. I have read that using the "%" as a wildcard can allow ranges of IP addresses, but is it possible to allow all of them? Thank you.
Replies 1
Avatar
0
BradM
Hi Eric3712, Yes, it is possible to allow all IP addresses to attempt to connect to your MySQL Databases. When using the Remote MySQL tool, set the Host to %.%.%.% That should allow all IP addresses to connect. Keep us updated on this issue by posting a comment at the bottom of the page after you've tested this! Thanks! - Brad