使用mysqld_multi实现单系统中配置多个MySQL服务器实例(4)

将/usr/local/mysql/bin加到$PATH环境变量里 
export PATH=/usr/local/mysql/bin:$PATH 
 
#查看数据库状态 
mysqld_multi --defaults-extra-file=/etc/mysqld_multi.cnf report 
#结果都为没有运行 
Reporting MySQL servers 
MySQL server from group: mysqld1 is not running 
MySQL server from group: mysqld2 is not running 
MySQL server from group: mysqld3 is not running 
MySQL server from group: mysqld4 is not running 
 
#启动 
mysqld_multi --defaults-extra-file=/etc/mysqld_multi.cnf start 
#结果为 
Reporting MySQL servers 
MySQL server from group: mysqld1 is not running 
MySQL server from group: mysqld2 is not running 
MySQL server from group: mysqld3 is not running 
MySQL server from group: mysqld4 is not running 
 
#启动具体某一个实例可在start、stop后面加上具体数据1,2,3等 

8、查看运行结果

复制代码 代码如下:

#查看相应端口是否已经被监听 
netstat -tunlp 
 
#查看是否有活动进程 
ps -aux|grep mysql 

9、登录相应数据库

复制代码 代码如下: