MySQL: [08S01] Communications link failure

Question

I have an application with local DB, which is H2. But customer is using MySQL. There were some issues on customer side, so I decided to install and run an application against MySQL on local machine (MacOS). I am using java 9.

Current setup:

After click on "Test Connection" I am getting following error.

There is a lot of comments:

packet drops or badly configured Firewall/Switch

a lot of transaction

known bug - solution in maven dependency

But most of them are not in test connection, but in configuration. Also the connection for those guys works at least once or through another set of firewalls. None of the previous solutions fit my case.

I also try to restart MySQL with:

sudo service mysql restart

With the result:

service: command not found

Or just to check the status with:

sudo service mysql status

With the result:

service: command not found

I dont know if it is connected to my issue? Is db running "forever" or idea will run it only when I will run the app? Could anyone help with connection to db?

https://askubuntu.com/questions/82374/how-do-i-start-stop-mysql-server Check this link may help you — Jay Shankar Gupta, Apr 10 '18 at 11:54
I tried with no result. After all I restarted and it showed me error message with expired password (which was one from mysql, I never changed it). To change password I have to install MySQL workbench, change pass and now it works. Anyway thank you! — Beginner, Apr 11 '18 at 05:46

score 11 · Answer 1 · edited Apr 06 '22 at 13:58

11

I simply changed the driver to Amazon Aurora MySQL despite having a simple mysql database on a VPS.

edited Apr 06 '22 at 13:58

Eric Aya

69,473
35
181
253

answered Apr 06 '22 at 12:28

Flavio Troia

2,451
1
25
27

Thank you, changing the driver was the solution> I've changed it from mysql to amazon aurora mysql – Soma Bini Jul 21 '22 at 14:55

score 7 · Answer 2 · edited Mar 02 '19 at 02:58

7

I ran into similar error when trying have JetBean Datagrip and Pycharm to connect to mySQL server hosted by Amazon.

I am able to fix this issue by using an earlier version of my SQL driver.

For example:

edited Mar 02 '19 at 02:58

kosist

2,868
2
17
30

answered Mar 01 '19 at 22:29

RyanS

71
1
2

This has just saved me – Victor Leal Oct 26 '22 at 19:09

score 0 · Accepted Answer · answered Apr 11 '18 at 06:47

0

I tried with no result. After all I restarted and it showed me error message with expired password (which was one from mysql, I never changed it). To change password I have to install MySQL workbench, change pass and now it works. Anyway thank you!

answered Apr 11 '18 at 06:47

Beginner

207
3
6
12

MySQL: [08S01] Communications link failure

3 Answers3