Unable to connect to mySQL database

Category: Databases

westis5
Asked:
2013-03-29 5:34 pm EST

Hits: 1,478
Hi,

I have added my host to the Remote Database Access Hosts list, but I am getting the following error when my app tries to connect to my database:

SQLSTATE[HY000] [1129] Host '198.46.81.137' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'.

I have a shred server account so I don't have access to mysqladmin. How do I flush-hosts?

thanks,
Eli

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

You must login before you can submit an answer.

Hi,
It is interesting I HAVE the same PROBLEM today
Please how to make it
Thanks Frank
FrankDo
0 Points
2013-03-29 07:16 pm EST

OTHER ANSWERS

0

jamesr
Staff
5,889 Points
2013-04-01 10:17 am EST
Thank you for your question westis5!

Sorry for the problem connecting to your database. I was able to connect remotely with a 3rd party application. Also, 198.46.81.137 is not blocked in the firewall on the server. Make sure you have done the following.

1. Create a user for the database and add the user with full Permissions.
2. Try adding a % for testing in the Remote MySQL to open all connections

If you are still having trouble connecting after those steps, please contact tech support so they can review your logs when you connect. Sorry for the trouble.

Best Regards,
James R

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!