根据工作环境,自定义一个mysql启动脚本
---1.保存为/usr/local/mysql/scripts/mysql_env.ini
#set mysql init variables
mysql_user=system #mysql的用户名
mysql_pass='password' #mysql的登录用户密码
#check input parameter or no
if [ $# -ne 1 ] ; then #判断输入的参数个数
echo mysql port is 3306
mysql_port=3306
else
mysql_port=$1 #$1是传入的第1个位置参数
echo mysql port is $1
fi
---2.启动mysql
#!/bin/sh
#ocpyang@126.com
my_cnf=/usr/local/mysql/my.cnf #mysql的配置文件
mysqld_safe=/usr/local/mysql/bin/mysqld_safe
source /usr/local/mysql/scripts/mysql_env.ini
errorlog=`grep -i ^log-error $my_cnf |cut -d = -f 2`
init_num=1
portnum=`netstat -lnt|grep ${mysql_port}|wc -l`
if [ ! -x $mysqld_safe ]; then
echo mysql安装时启动文件未安装到$mysqld_safe或无执行权限
exit 1 #0是执行成功,1是执行不成功
else
if [ $portnum = 1 ]; then
echo a mysqld process already exists,please stop mysql at first!
exit 0
else
echo 启动本机mysql端口为:$mysql_port的服务
$mysqld_safe --defaults-file=$my_cnf > /dev/null &
while [ $init_num -le 5 ]
do
portnum=`netstat -lnt|grep ${mysql_port}|wc -l`
echo mysql启动中....请稍等...
sleep 5
if [ $portnum = 1 ];
then
echo mysql ****启动成功****
exit 0
fi
init_num=$(($init_num +1))
done
fi
echo -e mysql启动失败,请检查错误日志`echo 'cat ' ${errorlog}`
echo *****************************************
exit 0
fi
---3.加入环境变量即可
echo export path=/usr/local/mysql/scripts:/$path>>~/.bash_profile
source ~/.bash_profile