mariadb是MySQL的分支,CentOS YUM中存在mariadb的源,因此安装相对容易
1,清除yum源缓存数据
yum clean all
2,查看是否安装了maeiadb
[root@localhost ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
此时显示已安装,先将其删除
[root@localhost ~]# rpm -qa | grep mariadb
mariadb-libs-5.5.56-2.el7.x86_64
3,安装mariadb
yum -y install mariadb-server mariadb-client
4,设置开机自启动
[root@localhost ~]# systemctl start mariadb.service
[root@localhost ~]# systemctl enable mariadb.service
5,设置密码
[root@localhost ~]# mysql -uroot -p
Enter password:
当前默认密码为空,直接点击回车就好;
MariaDB [(none)]> use mysql
修改数据库密码为root:
MariaDB [mysql]> update mysql.user set password('root') where user='root';
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
查看数据库:
MariaDB [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
修改完后执行:
MariaDB [mysql]> flush privileges;
Query OK, 0 rows affected (0.00 sec)
使语句生效。