原文：https://blog.csdn.net/pengjunlee/article/details/81212250

1、卸载mariadb

1)查看mariadb

[root@localhost ~]# rpm -qa|grep mariadb

mariadb-libs-5.5.52-1.el7.x86_64

2)卸载

rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64

2、下载并安装mysql

1)下载安装包

进入并创建安装目录 mkdir /var/mysql

*下载安装包

 wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

*安装mysql

rpm -ivh mysql-community-release-el7-5.noarch.rpm

安装完成之后，会在 /etc/yum.repos.d/ 目录下新增 mysql-community.repo 、mysql-community-source.repo 两个 yum 源文件

yum install mysql-server

检查mysql是否安装成功

rpm -qa | grep mysql

*启动/停止/重启mysql

systemctl start/stop/restart mysqld

设置开机自启动

systemctl enable mysqld

2)配置

复制配置文件到/etc/my.cnf中

cp /support-files/my-default.cnf /etc/my.cnf

设置表名不区分大小写 

在[mysql]节点下添加 lower_case_table_names=1,再重启mysql ,systemctl restart mysqld

3)添加远程用户

grant all privileges on *.* to admin@"%" identified by 'something' with grant option;

添加了一个账号admin，密码something的远程用户

执行 flush privileges；