CentOS7.x安装配置MySQL8.0单节点

yum安装

> wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
> yum install -y mysql80-community-release-el7-3.noarch.rpm
> yum install -y mysql-community-server --nogpgcheck

启动

> systemctl start mysqld

# 获取启动时的临时密码（在第一次登录时就是用这个密码）
> grep 'temporary password' /var/log/mysqld.log

# 如果没有获取到临时密码，则删除原来安装过的mysql残留的数据
> rm -rf /var/lib/mysql

# 再启动mysql
> systemctl start mysqld

# 登录
> mysql -uroot -p

输入刚刚获取的临时密码。

修改配置

# 登录成功后修改密码
mysql> SHOW VARIABLES LIKE 'validate_password%';

# 降低密码策略与复杂度
mysql> SET global validate_password.policy=LOW;
mysql> SET global validate_password.length=6;
mysql> ALTER USER USER() IDENTIFIED BY '123456';
mysql> USE mysql;
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
mysql> ALTER USER 'root'@'%' IDENTIFIED BY '123456';
mysql> FLUSH PRIVILEGES;

# 开启远程控制
mysql -u root -p
mysql> USE mysql;
mysql> UPDATE user SET host='%' WHERE user='root';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
mysql> FLUSH PRIVILEGES;

# 修改字符集
> vi /etc/my.cnf

[mysqld]
character_set_server=utf8mb4
init_connect='SET NAMES utf8mb4'
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

# 如果是在阿里云上配置MySQL，为了能够远程访问还需要在`[mysqld]`中添加
bind-address=0.0.0.0

---

感谢支持

更多内容，请移步《超级个体》。