1. mysql官方下载yum源
2. 安装mysql源
3. yum安装
4. 检查mysql源是否安装成功(如图,即安装成功)
5. 查看默认生成的密码
grep ‘temporary password‘ /var/log/mysqld.log
6. 修改密码
ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘MyNewPass4!‘;
7. 默认安装了密码安全检查插件,如不需要,在my.cnf添加配置(重启生效)
validate_password = off
8. 添加远程登录用户
GRANT ALL PRIVILEGES ON *.* TO ‘yangxin‘@‘%‘ IDENTIFIED BY ‘Yangxin0917!‘;
9. 配置默认编码为utf8
(1)修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置,如下所示:
[mysqld] character_set_server=utf8 init_connect=‘SET NAMES utf8‘
(2)重启mysql并查看
show variables like ‘%character%‘;