0.0.0.0:3308 0.0.0.0:* LISTEN 2348/mysqld
unix 2 [ ACC ] STREAM LISTENING 10780 2348/mysqld /tmp/mysql3308.sock
9 初始化密码并且授权远程登录，mysqladmin用户名和密码需要和/ect/my.cnf中保持一致，否则stop不了服务。
# /usr/local/mysql/bin/mysqladmin -u root password "CleverCode123" -S /tmp/mysql3306.sock
# /usr/local/mysql/bin/mysql -uroot -pCleverCode123 -S /tmp/mysql3306.sock
mysql> grant all privileges on *.* to 'root'@'%' identified by 'pwd3306' with grant option;
mysql> flush privileges;
# /usr/local/mysql/bin/mysqladmin -u root password "CleverCode123" -S /tmp/mysql3307.sock
# /usr/local/mysql/bin/mysql -uroot -pCleverCode123 -S /tmp/mysql3307.sock
mysql> grant all privileges on *.* to 'root'@'%' identified by 'pwd3307' with grant option;
mysql> flush privileges;
# /usr/local/mysql/bin/mysqladmin -u root password "CleverCode123" -S /tmp/mysql3308.sock
# /usr/local/mysql/bin/mysql -uroot -pCleverCode123 -S /tmp/mysql3308.sock
mysql> grant all privileges on *.* to 'root'@'%' identified by 'pwd3308' with grant option;
mysql> flush privileges;
10 停止（必须先初始化密码）。可以使用netstat -anp | grep 3308查看监听进程是否还存在
# /usr/local/mysql/bin/mysqld_multi stop 3306
# /usr/local/mysql/bin/mysqld_multi stop 3307
# /usr/local/mysql/bin/mysqld_multi stop 3308
11 报告。显示进程的状态
# /usr/local/mysql/bin/mysqld_multi report 3306
# /usr/local/mysql/bin/mysqld_multi report 3307
# /usr/local/mysql/bin/mysqld_multi report 3308
|