CentOS7 yum方式安装MySQL57(简单 好用)

发表于

CentOS7 yum方式安装MySQL5.7

  1. 下载并安装MySQL官方的 Yum Repository
1
2
3
java复制代码wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
yum localinstall mysql57-community-release-el7-8.noarch.rpm -y
yum install mysql-community-server mysql -y
  1. MySql初始化及配置
1. 启动: `systemctl start mysqld`
2. 查看状态: `systemctl status mysqld`


![image.png](https://gitee.com/songjianzaina/juejin_p11/raw/master/img/27bbfd7a5edf8baeb08b9b324a85041a3eaf93aeaf0ff4047a5ef4d0a765b2b9)
3. 查看初始密码: `grep "password" /var/log/mysqld.log`
![在这里插入图片描述](https://gitee.com/songjianzaina/juejin_p11/raw/master/img/36db3f1ff44d43a825bbfb41cc32b3fad09cdcd41fbd4206112e472c9d64e898)
4. 登录: mysql -uroot -p'查到的密码'
5. 这个两个设置以后 密码很简单不会报错




1
2
java复制代码set global validate_password_policy=0;        
set global validate_password_length=1;


6. 修改密码: `ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';`
7. 启用远程连接: `grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;`
8. 刷新权限: flush privileges;
9. 修改默认字符集: vi /etc/my.cnf




1
2
3
4
5
6
7
8
9
java复制代码[mysqld]
default-storage-engine=INNODB
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4


10. 重启mysql: `systemctl restart mysqld`
11. 开机启动: `systemctl enable mysqld`
12. 取消使用yum时每次都加载mysql: `yum -y remove mysql57-community-release-el7-8.noarch`

本文转载自: 掘金

开发者博客 – 和开发相关的 这里全都有

0%