centos7安装mysql5.7

最新推荐文章于 2025-07-10 13:51:25 发布

原创最新推荐文章于 2025-07-10 13:51:25 发布 · 298 阅读

CC 4.0 BY-SA版权

1 篇文章

订阅专栏

1)去官网下载myql的yum源安装包(mysql57-community-release-el7-11.noarch.rpm)

2)安装myql的yum源

[root@xinglinglove local]# yum localinstall mysql57-community-release-el7-11.noarch.rpm

3)通过yum安装msyql

[root@xinglinglove local]# yum install -y mysql-community-server

4)查看msyql服务状态

[root@xinglinglove local]# systemctl status mysqld.service

5)启动mysql服务

[root@xinglinglove local]# systemctl start mysqld.service

6)查看mysql密码

[root@xinglinglove ]# cat /etc/my.conf

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

[root@xinglinglove ]# more /var/log/mysqld.log

2017-08-23T11:42:20.569786Z 1 [Note] A temporary password is generated for root@localhost: vrwrge#&4/oA

7)登陆mysql

[root@xinglinglove ]# msyql

8)修改密钥复杂度配置

mysql> set global validate_password_policy=0;

mysql> set global validate_password_length=6;

9)修改密码

mysql> alter user 'root'@'localhost' identified by '123456';

10)开启远程访问

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

mysql> flush privileges;