在centos7下安装mysql

1.一般centos7默认安装了mariadb,这里把它卸载。

rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64

2.rpm安装mysql

rpm -ivh mysql-community-common-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.30-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.24-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.24-1.el7.x86_64.rpm

3.修改selinux，关闭selinux防火墙
临时：

setenforce 0

永久：

/etc/selinux/config
SELINUX=disabled

4.修改mysql配置文件

/etc/my.cnf

比如修改端口：port=10032

5.启动mysql服务

systemctl start mysqld

6.查看mysql初始密码

grep password /var/log/mysqld.log

7.进入mysql

mysql -uroot –p

8.修改密码级别

set global validate_password_policy=0;

9.修改密码

set password = password("yfbzx,./");

10.创建用户授权

grant all privileges on *.* to 'test'@'%' identified by '123456';

11.刷新

flush privileges;