MySQL single host multi-instance root login problem

Suppose you have multiple MySQL instances on a single machine. For example, the port number is 3306. 3307. 3308

Choose a different Mysql.sock file when you log in

mysql-uroot-p123456 This sentence is a 3306 instance of the login
Mysql-uroot-p123456-s/home/mysql_3307/mysql.sock This sentence is a 3307 instance of the login

At this time with the-P 3307 This option is no use.

This-p option and-H should be used together.

The native login appears to be using this sock file.

UNIX sockets

MySQL single host multi-instance root login problem