mysql不同端口，不同配置文件，不同pid启动

翔子

1. #!/bin/bash
   
2. 
   
3. for port in 3306 3307 3308;
   
4. do
   
5. rundir=/data/mysql/$port
   
6. filedir=/tmp
   
7. 
   
8. echo “start mysql server on port $port…”
   
9. 
   
10. /usr/local/mysql/bin/mysqld_safe –defaults-file=$rundir/my.cnf –port=$port –user=mysql –datadir=$rundir/data/ –pid-file=$filedir/mysql.”$port”.pid –socket=$filedir/mysql.”$port”.sock &
    
11. sleep 5
    
12. chmod 0777 $filedir/mysql.”$port”.sock
    
13. done

复制代码

修改成你的rundir和filedir

连接mysql的shell脚本

1. #!/bin/bash
   
2. 
   
3. port=$1
   
4. user=$2
   
5. 
   
6. echo “connect mysql server localhost $port by $user through /tmp/mysql.$port.sock”
   
7. mysql -hlocalhost -P$port -u$user -p -S/tmp/mysql.$port.sock

复制代码