How to allow all remote hosts in MySQL

Category: Databases

Eric3712
Asked:
2012-03-02 9:43 pm

Hits: 2,166
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
2012-03-02 9:53 pm
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?

Support Center Login

Latest Questions

If you need some help, submit your question to our Community!
We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)
Ask a Question!
Recent Questions
  1. Can I create a website on another website (e.g. Wix) and have it hosted on my inmotion domain?
  2. Why can't I see my updated web files on my website?
  3. Adding Google Analytics
Browse other questions

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!