mysql不同端口，不同配置文件，不同pid启动
#!/bin/bashfor port in 3306 3307 3308;
do
rundir=/data/mysql/$port
filedir=/tmp
echo “start mysql server on port $port…”
/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 &
sleep 5
chmod 0777 $filedir/mysql.”$port”.sock
done
修改成你的rundir和filedir
连接mysql的shell脚本
#!/bin/bash
port=$1
user=$2
echo “connect mysql server localhost $port by $user through /tmp/mysql.$port.sock”
mysql -hlocalhost -P$port -u$user -p -S/tmp/mysql.$port.sock
页:
[1]