How to allow all remote hosts in MySQL

Avatar
  • 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.
Avatar
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