MySQL8.0安装配置(Linux)

MySQL8.0安装配置(Linux) 

1.下载

官方下载地址：downloads.mysql.com/archives/community/ 

通过百度网盘分享的文件：mysql8.0.zip
链接：https://pan.baidu.com/s/16WjFA45Bk2ATCHnr0-NG-g 
提取码：3m7l 

2.上传

//创建mysql目录，上传以上全部文件到目录
[root@hadoop01 ~]# mkdir /opt/software/mysql
[root@hadoop01 ~]# cd /opt/software/mysql/

//卸载MySQL依赖，虽然机器上没有装MySQL，但是这一步不可少,提示输入y确定
sudo yum remove mysql-libs

//下载依赖并安装
sudo yum install libaio
sudo yum -y install autoconf

3.安装

 执行/opt/software/mysql/目录下install_mysql.sh 

su root #切换到root用户
sh install_mysql.sh #调用启动脚本

install_mysql.sh脚本内容

#!/bin/bash
set -x
[ "$(whoami)" = "root" ] || exit 1
[ "$(ls *.rpm | wc -l)" = "7" ] || exit 1
test -f mysql-community-client-8.0.31-1.el7.x86_64.rpm && \
test -f mysql-community-client-plugins-8.0.31-1.el7.x86_64.rpm && \
test -f mysql-community-common-8.0.31-1.el7.x86_64.rpm && \
test -f mysql-community-icu-data-files-8.0.31-1.el7.x86_64.rpm && \
test -f mysql-community-libs-8.0.31-1.el7.x86_64.rpm && \
test -f mysql-community-libs-compat-8.0.31-1.el7.x86_64.rpm && \
test -f mysql-community-server-8.0.31-1.el7.x86_64.rpm || exit 1

# 卸载MySQL
systemctl stop mysql mysqld 2>/dev/null
rpm -qa | grep -i 'mysql\|mariadb' | xargs -n1 rpm -e --nodeps 2>/dev/null
rm -rf /var/lib/mysql /var/log/mysqld.log /usr/lib64/mysql /etc/my.cnf /usr/my.cnf

set -e
# 安装并启动MySQL
yum install -y *.rpm >/dev/null 2>&1
systemctl start mysqld

#更改密码级别并重启MySQL
sed -i '/\[mysqld\]/avalidate_password.length=4\nvalidate_password.policy=0' /etc/my.cnf
systemctl restart mysqld

# 更改MySQL配置
tpass=$(cat /var/log/mysqld.log | grep "temporary password" | awk '{print $NF}')
cat << EOF | mysql -uroot -p"${tpass}" --connect-expired-password >/dev/null 2>&1
set password='000000';
update mysql.user set host='%' where user='root';
alter user 'root'@'%' identified with mysql_native_password by '000000';
flush privileges;
EOF

 4.使用

#链接MySQL
mysql -uroot -p000000
#退出MySQL
quit

#mysql8.0之后的版本root用户连接问题，修改权限，刷新
#脚本里面不生效的话，手动执行一遍
mysql> alter user 'root'@'%' identified with mysql_native_password by '000000';
mysql> flush privileges;