Linux安装MySQL5.7详细步骤

1、查看linux环境中是否自带了mysql

yum list installed | grep mysql

2、删除自带的mysql

yum -y remove mysql-libs.x86_64

3、给CentOS添加rpm源。

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

4、安装下载好的rpm文件

yum install mysql-community-release-el6-5.noarch.rpm -y

5、切换到/etc/yum.repos.d/目录下

6、修改mysql-community.repo文件中的enabled属性，使用5.7版本，禁用其他版本

7、安装mysql

命令：yum install mysql-community-server -y

8、启动mysql

service mysqld start

9、获取临时密码

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

10、使用临时密码登录

mysql -uroot -p

11、修改密码

set global validate_password_policy=0;
set global validate_password_length=1;
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

12、修改远程访问权限

grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;