一键安装mysql5.7_一键部署----shell脚本安装MySQL5.7

以你之姓@ 2022-11-06 00:53 211阅读 0赞

一键部署----shell脚本安装MySQL5.7

\#/bin/bash

yum -y install ncurses bison cmake gcc gcc-c++ ncurses-devel

useradd mysql -s /sbin/nologin

read -p "输入你存放压缩包的绝对路径：" abc

cd $abc

tar zxvf boost\_1\_59\_0.tar.gz

tar zxvf mysql-5.7.17.tar.gz

mv boost\_1\_59\_0 /usr/local/boost

cd mysql-5.7.17/

cmake -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DMYSQL\_UNIX\_ADDR=/usr/local/mysql/mysql.sock -DSYSCONFDIR=/etc -DSYSTEMD\_PID\_DIR=/usr/local/mysql -DDEFAULT\_CHARSET=utf8 -DDEFAULT\_COLLATION=utf8\_general\_ci -DWITH\_INNOBASE\_STORAGE\_ENGINE=1 -DWITH\_ARCHIVE\_STORAGE\_ENGINE=1 -DWITH\_BLACKHOLE\_STORAGE\_ENGINE=1 -DWITH\_PERFSCHEMA\_STORAGE\_ENGINE=1 -DMYSQL\_DATADIR=/usr/local/mysql/data -DWITH\_BOOST=/usr/local/boost -DWITH\_SYSTEMD=1

make

make install

chown -R mysql:mysql /usr/local/mysql/

cd /etc

rm -rf my.cnf

touch my.cnf

echo "\[client\]" >>my.cnf

echo "port = 3306" >>my.cnf

echo "default-character-set=utf8" >>my.cnf

echo "socket = /usr/local/mysql/mysql.sock" >>my.cnf

echo " " >>my.cnf

echo "\[mysql\]" >>my.cnf

echo "port = 3306" >>my.cnf

echo "default-character-set=utf8" >>my.cnf

echo "socket=/usr/local/mysql/mysql.sock" >>my.cnf

echo " " >>my.cnf

echo "\[mysqld\]" >>my.cnf

echo "user = mysql" >>my.cnf

echo "basedir = /usr/local/mysql" >>my.cnf

echo "datadir=/usr/local/mysql/data" >>my.cnf

echo "port = 3306" >>my.cnf

echo "character\_set\_server=utf8" >>my.cnf

echo "pid-file = /usr/local/mysql/mysqld.pid" >>my.cnf

echo "socket = /usr/local/mysql/mysql.sock" >>my.cnf

echo "server-id = 1" >>my.cnf

echo " ">>my.cnf

echo "sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_AUTO\_VALUE\_ON\_ZERO,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,PIPES\_AS\_CONCAT,ANSI\_QUOTES" >>my.cnf

chown mysql.mysql /etc/my.cnf

echo 'PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' >> /etc/profile

echo 'export PATH' >> /etc/profile

source /etc/profile

cd /usr/local/mysql/

bin/mysqld \\

\--initialize-insecure \\

\--user=mysql \\

\--basedir=/usr/local/mysql \\

\--datadir=/usr/local/mysql/data

cp usr/lib/systemd/system/mysqld.service /lib/systemd/system/

systemctl daemon-reload