MySQL: root Login for multiple instances on one host, mysqlroot

MySQL: root Login for multiple instances on one host, mysqlroot

If multiple MySQL instances are created on one machine, for example, the port number is 3306,330 7, 3308

Select a different mysql. sock file when logging on.

Mysql-uroot-p123456 logs on to 3306 of instances.
Mysql-uroot-p123456-S/home/mysql_3307/mysql. sock logs on to the 3307 instance.

In this case, the-P 3307 option is not used. The-P option and-h should be used together.

This sock file has been logged on to the local machine.