浅谈 MySQL

jlthlx

#!/bin/bash　　# file name: install_mysql.sh
　　# function: install a secure mysql server automatically or manully.
　　# installation regulation: 1) mysql home directory: /usr/local/mysql-5.0.27
　　#                          2) directories data and log are created to optimize mysql directory structure.
　　#                          3) rename mysql user "root" to your prefered one and set password for it
　　#                          4) install customerized my.cnf to /etc/my.cnf
　　#                          5) install auto-start script to /etc/init.d/mysql
　　# usage: this script supports two installation mode:
　　#         1) auto-installation:  you need input nothing.and the result is default setting, that is,
　　#                                the username of mysql DBA is "mysql_admin" and its password is
　　#                               "passwd4mysql_admin".
　　#         2) manual-installation: during the installation process, you will be prompted to make sure
　　#                                 every step is ok and input username of mysql DBA and its password.
　　#        how to select installation mode? locate the comment: "# select install mode" and that is.
　　# Note: the auto-installation mode is the prefered one. but if you failed to install mysql