I'm unable to connect to MySQL 5.1 from my workbench 8.0, getting 'handshake' error

Avatar
  • updated
  • Answered
Duplicates 2
i cant connecct my sql work bench with db why
MySQL Workbench connection blocked
Hi,

I screwed up with username and/or password while trying to connect to our database with MySQL Workbench and now my host machine got blocked. I should run mysqladmin flush-hosts command, but I can't find any tool for that. So, how can I flush hosts to enable access again?

Br, Tero
Avatar
IMH Support Agent 1
  • Answered

Hello Praveen,

Thank you for contacting us about issues connecting to MySQL. Here is a link to our guide on setting up a Remote MySQL Database Connection. Ensure you have added your IP address to the firewall.

Also, make sure your database user is assigned to the database.

Thank you,

John-Paul

Avatar
johnpaulb-imhs1
Hello BlueSaga, Thank you for your question. There is no hard limit for failed database connection attempts. I recommend ensuring the connecting server's IP address is added to Remote MySQL in cPanel. This allows the connection through the firewall. If you have any further questions, feel free to post them below. Thank you, -John-Paul