MySQL Admin script

1. Environment files

-bash-4.1$ more Mysql_env.ini#!/bin/sh#set envmysql_user=rootmysql_pass=123456 ' #check parameterif [$#-ne 1]then        Host_port=3306else        host_port=$1fi-bash-4.1$

2. Create a startup script

-bash-4.1$ more Mysql_db_startup.sh#!/bin/shsource/opt/mysql/scripts/mysql_env.iniecho "Startup MySQL Service: Localhost_ "${host_port}/opt/mysql/bin/mysqld_safe--defaults-file=/opt/mysql/my.cnf  

3. Create a close script

-bash-4.1$ more Mysql_db_shutdown.sh#!/bin/shsource/opt/mysql/scripts/mysql_env.iniecho "shutdown MySQL Service: Localhost_ "${host_port}/opt/mysql/bin/mysqladmin--defaults-file=/opt/mysql/my.cnf-u${mysql_user}-p${MYSQL_PASS }-hlocalhost  shutdown-bash-4.1$

4. Create a quick Login script

5. Add the above script directory to the PATH environment variable
echo "Export path=/opt/mysql/scripts/:\ $PATH" >> ~/.bash_profile

SOURCE ~/.bash_profile

MySQL Admin script