一、检查安装环境

1. 查看是否已安装服务

[root@bogon ~]# rpm -qa | grep mysql
[root@bogon ~]# rpm -qa | grep mariadb
image.png
[root@bogon ~]# rpm -e —nodeps mariadb-libs-5.5.64-1.el7.x86_64

备注：
卸载服务用 ：rpm -e —nodeps rpm包名

2. 删除残留文件

[root@bogon ~]# rm -rf /var/lib/mysql
[root@bogon ~]# rm -rf /etc/my.cnf
[root@bogon ~]# rm -rf /usr/local/mysql
[root@bogon ~]# rm -rf /usr/lib64/mysql

备注：如果/var/lib/mysql这个目录不删除，重新安装后，密码仍是之前密码，不会重新初始化！

二、安装MariaDB

1. yum安装mariadb

[root@bogon ~]# yum -y install mariadb mariadb-server

启动MariaDB：
[root@bogon ~]# systemctl start mariadb
[root@bogon ~]# systemctl status mariadb

设置开机启动：
[root@bogon ~]# systemctl enable mariadb

2. 设置mysql的远程访问

1）首次登陆mysql时，不需要密码
2）删除mysql数据库中user表里面用户名为空的行
delete from user where user = ‘’;
3）给root用户设置密码，密码必须是加密的
update user set password = password(‘123456’) where user = ‘root’;
4）给root用户所有的权限
grant all privileges on . to root@’%’ identified by ‘123456’ with grant option;

[root@bogon ~]# mysql
MariaDB [(none)]> show databases;
MariaDB [(none)]> use mysql;
MariaDB [mysql]> delete from user where user = ‘’;
image.png
MariaDB [mysql]> select host,user,password from user;
image.png
MariaDB [mysql]> grant all privileges on . to root@’%’ identified by ‘123456’ with grant option;
MariaDB [mysql]> flush privileges;

三、放行3306端口、或关闭防火墙

1. 关闭防火墙

[root@bogon ~]# systemctl stop firewalld
[root@bogon ~]# systemctl disable firewalld

2.防火墙放行3306端口

方法一：firewall-cmd —zone=public —add-port=3306/tcp —permanent
方法二：编辑vim /etc/firewalld/zones/public.xml，添加如下内容

[root@bogon ~]# systemctl restart firewalld

使用用户名登录mariadb：
[root@bogon ~]# mysql -u root -p
image.png