安装与配置 mysql

1. 安装与配置 mysql

1.1. 安装

https://mirrors.tuna.tsinghua.edu.cn/help/centos/

# cp /etc/yum.repos.d /etc/yum.repos.d.bak -r
# sed -e 's|^mirrorlist=|#mirrorlist=|g' \
         -e 's|^#baseurl=http://mirror.centos.org|baseurl=https://mirrors.tuna.tsinghua.edu.cn|g' \
         -i.bak \
         /etc/yum.repos.d/CentOS-*.repo
# yum makecache
# yum install mysql-server

1.2. 配置

# systemctl status mysqld.service
# systemctl start  mysqld.service

# 查看密码信息
# cat /var/log/mysql/mysqld.log
root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

# mysql -u root -p

1.2.1. 设置密码

# mysql 8 直接用下面这行
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

# mysql 5 需要下面操作
# 设置密码可以为简单
# 设置为0判断密码的标准就基于密码的长度了。一定要先修改两个参数再修改密码
mysql> set global validate_password.policy=0;
# validate_password_length代表密码长度，最小值为4
mysql> set global validate_password.length=4; 

# 另外，以下命令可以查看密码规则
mysql> show variables like 'validate_password%';

1.2.2. 配置远程登录

mysql> use mysql;
mysql> update user set host="%" where user='root';
mysql> GRANT ALL ON *.* TO 'root'@'%'; # 重复敲 2 次
mysql> flush privileges;

解决mysql8报错：ERROR 1410 (42000): You are not allowed to create a user with GRANT

# 重复敲 2 次
mysql> GRANT ALL ON *.* TO 'root'@'%'; 

实在不行执行下面这行：

mysql> alter user test identified with mysql_native_password by 'new password';