1:下載mysql8文件
https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.18-el7-x86_64.tar.gz
2:新建一個(gè)my.cnf文件
vi my.cnf
[mysqld]
#skip-grant-tables
#collation_server=utf8_general_ci
#character_set_server=utf8
collation_server=utf8mb4_zh_0900_as_cs
character_set_server=utf8mb4
event_scheduler=ON
port=3390
mysqlx_port=33900
max_connections=1000
innodb_buffer_pool_size=3072M
table_open_cache=4000
key_buffer_size=384M
max_allowed_packet=4M
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=8M
myisam_sort_buffer_size=64M
thread_cache_size=64
default_authentication_plugin=mysql_native_password
datadir=/app/software/mysql8/data
socket=/app/software/mysql8/mysql.sock
#log-bin=mysql-bin?
lower_case_table_names=1
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
[mysqld_safe]
log-error=/app/software/mysql8/mysql.log
pid-file=mysql.pid
3: 把下載好的mysql安裝文件和my.cnf 放在同一個(gè)目錄下
4:新建一鍵安裝mysql腳本install_mysql8.sh
vi install_mysql8.sh
#!/bin/bash
#shell install Mysql8
#LiuQianMing? 2019-11-20 16:55:10
#tar gz
tar -zxvf mysql-8.0.18-el7-x86_64.tar.gz
mv mysql-8.0.18-el7-x86_64 mysql8
cp my.cnf mysql8
cd mysql8
#當(dāng)前登錄用戶
currentUser=$USER
#mysql 訪問(wèn)端口
mysqlPort=3390
#mysql 插件 端口
mysqlxPort=33900
#mysql root 密碼 根據(jù)實(shí)際需要設(shè)置
mysqlRootPasswd='xxxxxxx'
#mysql新增普通用戶名?根據(jù)實(shí)際需要設(shè)置
mysqlPublicUser=xxxx
#mysql新增普通用戶密碼?根據(jù)實(shí)際需要設(shè)置
mysqlPublicUserPasswd='xxxxx'
mysqlDir=$(cd $(dirname $0); pwd)
mkdir data
echo $(date +'%Y-%m-%d %H:%M:%S'):'開(kāi)始初始化數(shù)據(jù)庫(kù)啟動(dòng)文件my.cnf'
#sed -i '/mysqld/a\datadir=$mysqlDir/data' my.cnf;
sed -i '/^datadir=/c'\datadir=$mysqlDir\/data'' my.cnf
#sed -i '/mysqld/a\basedir=$mysqlDir' my.cnf;
sed -i '/^basedir=/c'\basedir=$mysqlDir'' my.cnf
#sed -i '/mysqld/a\port=3390' my.cnf;
sed -i '/^port=/c'\port=$mysqlPort'' my.cnf
#sed -i '/mysqld/a\port=3390' my.cnf;
sed -i '/^mysqlx_port=/c'\mysqlx_port=$mysqlxPort'' my.cnf
#sed -i '/mysqld/a\character_set_server=utf8mb4' my.cnf;
sed -i '/^character_set_server=/c'\character_set_server=utf8mb4'' my.cnf
#sed -i '/mysqld/a\collation_server=utf8mb4_zh_0900_as_cs' my.cnf;
sed -i '/^collation_server=/c'\collation_server=utf8mb4_zh_0900_as_cs'' my.cnf
#sed -i '/mysqld/a\event_scheduler=ON' my.cnf;
sed -i '/^event_scheduler=/c'\event_scheduler=ON'' my.cnf
#sed -i '/mysqld/a\socket=$mysqlDir/mysql.sock' my.cnf;
sed -i '/^socket=/c'\socket=$mysqlDir\/mysql.sock'' my.cnf
#sed -i '/mysqld/a\lower_case_table_names=1' my.cnf;
sed -i '/^lower_case_table_names=/c'\lower_case_table_names=1'' my.cnf
#sed -i '/mysqld/a\default_authentication_plugin=mysql_native_password' my.cnf;
sed -i '/^default_authentication_plugin=/c'\default_authentication_plugin=mysql_native_password'' my.cnf
#sed -i '/mysqld/a\skip-grant-tables' my.cnf;
#sed -i '/^skip-grant-tables=/c'\#skip-grant-tables'' my.cnf
sed -i '/^log-error=/c'\log-error=$mysqlDir\/mysql.log'' my.cnf
sed -i '/^pid-file=/c'\pid-file=$mysqlDir\/mysql.pid'' my.cnf
echo $(date +'%Y-%m-%d %H:%M:%S'):'開(kāi)始初始化數(shù)據(jù)庫(kù)啟動(dòng)文件mysql.server'
cp support-files/mysql.server $mysqlDir
#sed -i '46c\basedir=$mysqlDir' mysql.server;
sed -i '/^basedir=/c'\basedir=$mysqlDir'' mysql.server
#sed -i '47c\datadir=$mysqlDir/data' mysql.server;
sed -i '/^datadir=/c'\datadir=$mysqlDir\/data'' mysql.server
echo $(date +'%Y-%m-%d %H:%M:%S'):'開(kāi)始初始化數(shù)據(jù)庫(kù)'
$mysqlDir/bin/mysqld? --defaults-file=$mysqlDir/my.cnf? --initialize --user=$USER? --basedir=$mysqlDir --datadir=$mysqlDir/data --log-error=$mysqlDir/mysql.log
echo $(date +'%Y-%m-%d %H:%M:%S'):'數(shù)據(jù)庫(kù)初始化完成'
echo $(date +'%Y-%m-%d %H:%M:%S'):'開(kāi)始啟動(dòng)數(shù)據(jù)庫(kù)'
$mysqlDir/mysql.server start
#修改mysql登錄密碼
tempPasswd=`grep? 'temporary password'? $mysqlDir/mysql.log`
mysqlPasswd=`echo ${tempPasswd##*localhost:}`?
echo $(date +'%Y-%m-%d %H:%M:%S'):"臨時(shí)密碼：$mysqlPasswd"
echo $(date +'%Y-%m-%d %H:%M:%S'):'修改root密碼'
mysql -uroot -p"${mysqlPasswd}" -S? $mysqlDir/mysql.sock -e? "ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '$mysqlRootPasswd'"? --connect-expired-password
echo $(date +'%Y-%m-%d %H:%M:%S'):'修改root密碼成功'
echo $(date +'%Y-%m-%d %H:%M:%S'):'創(chuàng)建blekey用戶'
mysql -uroot -p"$mysqlRootPasswd" -S? $mysqlDir/mysql.sock -e? "CREATE USER '$mysqlPublicUser'@'%' IDENTIFIED BY '$mysqlPublicUserPasswd'"? --connect-expired-password
echo $(date +'%Y-%m-%d %H:%M:%S'):'創(chuàng)建xxx用戶成功'
echo $(date +'%Y-%m-%d %H:%M:%S'):'賦權(quán)x x x用戶'
mysql -uroot -p"$mysqlRootPasswd" -S? $mysqlDir/mysql.sock -e? "GRANT ALL ON *.* TO '$mysqlPublicUser'@'%'"? --connect-expired-password
echo $(date +'%Y-%m-%d %H:%M:%S'):'賦權(quán)xxx用戶成功'
echo $(date +'%Y-%m-%d %H:%M:%S'):'刷新權(quán)限'
mysql -uroot -p"$mysqlRootPasswd" -S? $mysqlDir/mysql.sock -e? "FLUSH PRIVILEGES"? --connect-expired-password
echo $(date +'%Y-%m-%d %H:%M:%S'):'刷新權(quán)限成功'
#如果當(dāng)前用戶是root配置etc下，如果是普通用戶則配置到對(duì)應(yīng)用戶下的環(huán)境變量
if [ "$currentUser" = "root" ];
? then
? ? sed? -i '$a? \export PATH='$mysqlDir'\/bin:$PATH'? /etc/profile
? ? source /etc/profile
? else
? ? sed? -i '$a? \export PATH='$mysqlDir'\/bin:$PATH'? /home/"$currentUser"/.bash_profile
? ? source /home/"$currentUser"/.bash_profile
fi
#sed -i '/^skip-grant-tables=/c'\#skip-grant-tables'' my.cnf
#$mysqlDir/mysql.server restart
