How to allow all remote hosts in MySQL
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.
Yes, it is possible to allow all IP addresses to attempt to connect to your MySQL Databases.
When using the <a href='http://www.inmotionhosting.com/support/website/databases/setting-up-a-remote-mysql-connection-in-cpanel' target='_blank'>Remote MySQL</a> tool, set the <strong>Host</strong> 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!
Like this Question? Tweet