mysql - idea [08S01] Communications link failure

Question

I just use IDEA recently and want to use IDEA to connect MySQL(8.0.12).but the IDEA indicate below

However, I use cmd could connect to my database,thus I did not configure out the problem.

I am in serah of many ways to solve this problem on tech forum but those are not working.

1. change mysql to lower version driver
2. set time_zone
3. add properties on url

question from:https://stackoverflow.com/questions/65867544/idea-08s01-communications-link-failure

Answer 1

There are a couple of things to check to solve the 'Communications links' failure.

One thing in particular is to check whether your MySQL server accepts TCP connections. In your terminal, it looks like you are using named pipes.

Make sure your MySQL server allows TCP connections; check for the bind-address configuration in mysql.ini under [mysqld] section. Its value should be at least 127.0.0.1, or set it as * to bind to all (not always a good idea).

Another point is the skip_networking configuration. Check if you have that, and remove and restart MySQL server. I believe this is set by default when you are installing MySQL.

(Also note that 8.0.17 is 'ancient' already).