-
下载mysql源安装包
wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
-
安装mysql源
yum localinstall mysql57-community-release-el7-10.noarch.rpm
-
安装MySQL
yum install mysql-community-server
-
启动MySQL服务
systemctl start mysqld
-
获取默认密码
grep 'temporary password' /var/log/mysqld.log
-
修改密码强度
mysql -u root -p登入
set global validate_password_mixed_case_count=0;
set global validate_password_number_count=3;
set global validate_password_special_char_count=0;
set global validate_password_length=6;
- 修改密码
set password for 'root'@'localhost'=password('123456');
修改编码为utf-8
- 在mysql 里查看 select version();
- 在/etc/my.cnf中 在mysqld标签下添加
character_set_server = utf8
- 授权MySql远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
Flush Privileges;
- 参考:https://blog.csdn.net/weixin_43123562/article/details/91042118