centos7安装MySQL

1. 安装可用的rpm包

wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm

2. 安装mysql服务

 yum -y install mysql-community-server

3. 启动mysql

systemctl start mysqld.service

4. 查看mysql服务状态

 systemctl status mysqld.service

5. 查找日志获取随机的初始密码

grep "password" /var/log/mysqld.log

6. 登录数据库

mysql -uroot -p

7. 修改密码

# 修改密码复杂度
set global validate_password_policy=LOW;
set global validate_password_length=6;
# 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';

8. 开启mysql远程访问

use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;

9. 关闭防火墙

systemctl stop firewalld.service

10. 修改默认编码

vim /etc/my.cnf

[client]
default-character-set=utf8
character-set-server=utf8
collation-server=utf8_general_ci

20200807125012307.png

11. 重启服务

service mysqld restart

12. 查看修改是否成功

show variables like '%character%';