Shulou(Shulou.com)06/01 Report--

In fact, MySQL added this function too late. In MariaDB 10.0 and Percona 5.6, there is a parameter extra_port that can be logged into the "backdoor" solution.

In MySQL version 8.0, a similar parameter implements this feature.

admin_address = 127.0.0.1admin_port = 13308create_admin_listener_thread = ON

Note: Dynamic modification is not supported. Restart mysqld process in my.cnf configuration file to take effect.

Q: How many connections do you have?

A: mysqld actually allows max_connections+ 1 client connections, providing user logins with SUPER privileges and PROCESS privileges.

Demo:

only need to specify

admin_port = 13308

13308 port number, you can connect.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.