先删掉自带的mariadb

rpm -qa|grep mariadb//查询

rpm -e mariadb-libsXXX（上面查到的文件） --nodeps

下载

wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.28-1.el7.x86_64.rpmbundle.tar

解压

tar xvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar

有界面的也可以直接双击

安装

需要到解压文件夹下

rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

rpm -ivh mysql-community-devel-5.7.28-1.el7.x86_64.rpm

初始化

mysqld --initialize --user=mysql

查看初始密码

cat /var/log/mysqld.log | grep password

或

grep 'temporary password' /var/log/mysqld.log

启动mysql

systemctl start mysqld

开机启动

systemctl enable mysqld

修改密码

mysql -uroot -p

xxxxxx输入初始密码

mysql> SET PASSWORD = PASSWORD('123456');

Query OK, 0 rows affected, 1 warning (0.00 sec)

退出mysql

mysql>quit

关闭防火墙（为集群做准备，会改配置就不用关闭了，每次重启都要开）

systemctl stop firewalld

修改配置文件（没需要就不改）

vi /etc/my.cnf 命令

a//开始修改

esc//退出修改

shift+；//返回命令

wq//保存

navicat连接失败

修改连接权限

mysql -u root -p

use mysql;

select host from user where user='root';

update user set host ='%' where user ='root';

flush privileges;

查看日志位置

show variables like 'general_log_file';