[toc] ## 一、步驟總述 這個基于腳本的自動化mysql安裝，是基于源碼版本編譯并完成安裝的腳本，整個安裝過程不是非常快，主要占用時間的過程是源碼編譯。 > 1-下載mysql 5.7的安裝包，注意請下載對應的**源碼包**； > 2-上傳腳本放置到和安裝包同目錄下； > 3-運行腳本自動安裝腳本； > 4-設置自啟動。 ## 二、安裝步驟 ### 1-下載安裝包 ```shell wget https://downloads.mysql.com/archives/get/p/23/file/mysql-boost-5.7.31.tar.gz ``` ### 2-編寫腳本 在mysql安裝包路徑下添加以下腳本： ``` #!/bin/bash source_dir="/home" #這里填寫安裝包的路徑 mysql_dir="/usr/local/mysql" mysql_package="mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz" #這里需要修改為安裝包的名稱 mysql_SRC_first=$(echo $mysql_package | sed 's/.tar.gz//g') mysql_SRC=$(echo $mysql_SRC_first | sed 's/boost-//g') function init() { # close selinux sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config setenforce 0 # check yes/no x86_64 if [ `uname -m` != "x86_64" ];then echo "your system is 32bit ,not install libunwind lib!" fi # download depend on the packages LANG=C yum -y install gperftools make cmake gcc gcc-c++ autoconf automake libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel libidn libidn-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-servers pcre pcre-devel mkdir $log_dir groupadd mysql && useradd mysql -s /sbin/nologin -g mysql echo "www and mysql user && group create!" } function mysql_install() { echo "######## start install mysql ########" ##test yes/no have mysqld/mariadb progress ps -ef|grep -w mysqld|grep -v "grep" &> /dev/null if [ $? -eq 0 ];then mysqlbasedir=`ps -ef|grep -w "mysqld"|grep -v "grep"|awk '{print $9}'|tr -d '\-\-'` mysqldatadir=`ps -ef|grep -w "mysqld"|grep -v "grep"|awk '{print $10}'|tr -d '\-\-'` fi rpm -qa | grep mariadb* &> /dev/null if [ $? -eq 0 ];then yum remove mariadb* -y fi ls /etc/my.cnf &> /dev/null if [ $? -eq 0 ];then mv /etc/my.cnf /etc/my.cnf.bak fi ls /etc/init.d/mysql &> /dev/null tar zxvf $mysql_package cd $mysql_SRC echo "start cmake..." cmake -DCMAKE_INSTALL_PREFIX=$mysql_dir -DMYSQL_UNIX_ADDR=$mysql_dir/mysql.sock -DSYSCONFDIR=$mysql_dir/etc -DSYSTEMD_PID_DIR=$mysql_dir -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_TCP_PORT=3306 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_PERFSCHEMA_STORAGE_ENGINE=1 -DMYSQL_DATADIR=$mysql_dir/data -DWITH_BOOST=boost -DWITH_SYSTEMD=1 > $log_dir/configure_mysql.log sleep 1 echo "start make && make install..." make && make install sleep 2 chown -R mysql.mysql $mysql_dir/ cd $mysql_dir/ echo '######create my.cnf######' if [ ! -s my.cnf ];then cat >> my.cnf << EOF [client] port = 3306 default-character-set=utf8 socket = /usr/local/mysql/mysql.sock [mysql] port = 3306 default-character-set=utf8 socket = /usr/local/mysql/mysql.sock [mysqld] user = mysql basedir = /usr/local/mysql datadir = /usr/local/mysql/data port = 3306 default-character-set=utf8 pid-file = /usr/local/mysql/mysqld.pid socket = /usr/local/mysql/mysql.sock server-id = 1 # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES EOF else continue fi chown mysql.mysql my.cnf cp $mysql_dir/support-files/mysql.server /etc/init.d/mysqld chmod +x /etc/init.d/mysqld echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile echo 'export PATH' >> /etc/profile source /etc/profile rm -rf $mysql_dir/data/* mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/ systemctl daemon-reload systemctl start mysqld systemctl enable mysqld ps -ef|grep mysql systemctl status mysqld echo '######mysql is install completed done.######' } init sleep 1 mysql_install ``` ### 3-執行腳本 運行腳本等待執行完畢，經測試這個過程是非常緩慢的，大概需要2個小時： ``` sh mysql.sh ``` ### 4-設置自啟動 ``` systemctl status mysqld ``` ### 5-mysql初始化設置 進入數據庫中（默認密碼為空） ```shell mysql -uroot -p mysql> use mysql; mysql> alter user `root`@`%` identified by "123456" ; mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; mysql> flush privileges; mysql> exit ``` > 參考材料：https://blog.csdn.net/hotkoko/article/details/106064642