安装MySQL
yum install https://repo.mysql.com//mysql80-community-release-el7-7.noarch.rpm
yum repolist enabled | grep "mysql.*-community.*"
yum module disable mysql
yum install mysql-community-server
修改mysql配置/etc/my.cnf
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4
[mysqld]
character-set-server=utf8mb4
collation-server=utf8mb4_general_ci
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
lower_case_table_names=1
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
启动MySQL并作初始化
systemctl start mysqld
获取MySQL密码
grep 'temporary password' /var/log/mysqld.log
修改密码
登录MySQL
mysql -uroot -p
修改密码
alter user 'root'@'localhost' identified by 'QianMo@123';
如果需要设置短密码，可以执行下面的语句
show variables like 'validate_password%';
set global validate_password.check_user_name=OFF;
set global validate_password.length=1;
set global validate_password.mixed_case_count=0;
set global validate_password.number_count=0;
set global validate_password.policy=LOW;
set global validate_password.special_char_count=0;
alter user 'root'@'localhost' identified by 'root';
设置允许远程连接
use mysql;
update user set host = '%' where user = 'root';
flush privileges;
alter user 'root'@'%' identified with mysql_native_password by 'root';
flush privileges;
还需要开放远程连接用的3306端口，因为是本地学习用，直接禁用防火墙
systemctl stop firewalld
systemctl disable firewalld
设置开机启动
systemctl enable mysqld
