MySQL 8.0 resolves Too many connection
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.
