How to allow all remote hosts in MySQL

Category: Databases

Eric3712
Asked:
2012-03-02 5:43 pm EST

Hits: 2,594
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.

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

BradM
Staff
5,399 Points
2012-03-02 5:53 pm EST
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

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!