Connection to Ubuntu System server MySQL error (Error: 10061)/JDBC connection to remote database error (java.

If you encounter the exception prompt in the client tool such as Dbeaver:

At this point, you need to log in to the server and set up your MySQL and restart MySQL as follows

1. Vim/etc/mysql/my.cnf

2. Configure the bind-address inside = 127.0.0.1

This one changed to Bind-address = 0.0.0.0

Cancel MySQL Server binding to the address!

Save exit after (Wq)

2.sudo/etc/init.d/mysql Restart (restart MySQL service)

If the following error also occurs:

Execute the following command in the server's MySQL database:

And then we can connect to the database.

Connection to Ubuntu System server MySQL error (Error: 10061)/JDBC connection to remote database error (java.