Shulou(Shulou.com)05/31 Report--

Editor to share with you to facilitate the management of mysql shell scripts, I believe that most people do not know much, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

[mysql@clark scripts] $ls

Mysql_db_shutdown.sh mysql_db_startup.sh mysql_env.ini mysqlplus.sh

[mysql@clark scripts] $more mysql_db_shutdown.sh

# / bin/sh

# Created by clark 20170918

Source / data/mysqldata/scripts/mysql_env.ini

Echo "Shutdown MySQL Service: localhost_" ${HOST_PORT}

/ usr/local/mysql/bin/mysqladmin-u ${MYSQL_USER}-p$ {MYSQL_PASS}-S / data/mysqldata/$ {HOST_PORT} / mysql.sock shutdown

[mysql@clark scripts] $

[mysql@clark scripts] $

[mysql@clark scripts] $more mysql_db_startup.sh

# / bin/sh

# Created by clark 20170918

Source / data/mysqldata/scripts/mysql_env.ini

Echo "Startup MySQL Service: localhost_" ${HOST_PORT}

/ usr/local/mysql/bin/mysqld_safe-- defaults-file=/data/mysqldata/$ {HOST_PORT} / my.cnf &

[mysql@clark scripts] $

[mysql@clark scripts] $

[mysql@clark scripts] $more mysql_env.ini

# set env

MYSQL_USER=system

MYSQL_PASS='welcome123'

# check parameter

If [$#-ne 1]

Then

HOST_PORT=3306

Else

HOST_PORT=$1

Fi

[mysql@clark scripts] $

[mysql@clark scripts] $more mysqlplus.sh

# / bin/sh

# Created by clark 20170918

Source / data/mysqldata/scripts/mysql_env.ini

Echo "Login MySQL Service: localhost_" ${HOST_PORT}

/ usr/local/mysql/bin/mysql-u ${MYSQL_USER}-p$ {MYSQL_PASS}-S / data/mysqldata/$ {HOST_PORT} / mysql.sock

The above is all the contents of the article "what are the shell scripts that are easy to manage mysql?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.