Mysql remote connection

mysql on the linux server can be linked by programs on the server

but when you use netstat to view the port of open, you can"t see the information of port 3306

.

confirmed that bind-address already exists in the my.cnf file

now my local mysql GUI cannot connect to the mysql on the server

Please solve the doubts of the great gods

Mar.14,2021

linux Server mysql if you can usually connect to the server and make sure that your 3306 port is open, you need to add a remotely connected user to the user table of the database, whose Host field must be % . Here is an operation article handling methods that cannot be accessed by mysql database under CentOS

the second half of the article describes how to add a remote connection. I hope it will be helpful to you!

Menu