# 	命令
> ##一丶安装

[root@VM-0-16-centos /]# yum install mariadb-server   安装mariadb数据库
	[root@VM-0-16-centos /]# yum clean all  			  如下载失败 则 运行此命令清空下载文件
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/17/kuangstudy4e1d133d-1e3b-41b1-baaf-625878da77ec.jpg)
>##二丶数据库的启动，关闭，重启，设置
	[root@VM-0-16-centos /]# systemctl  start  mariadb		启动mariadb数据库
	[root@VM-0-16-centos /]# systemctl  restart  mariadb		重启mariadb数据库
	[root@VM-0-16-centos /]# systemctl  stop  mariadb			停止mariadb数据库
	[root@VM-0-16-centos /]# systemctl  enable mariadb			设置开机自启
	[root@VM-0-16-centos /]# systemctl  disable mariadb			关闭开机自启
>##三丶数据库初始化操作
	[root@VM-0-16-centos /]# mysql_secure_installation			初始化数据库
####初始化选项
1，Enter current password for root (enter for none):  	输入数据库超级管理员密码，这里第一次直接回车
2，Set root password? [Y/n] y								设置root密码
New password: 
Re-enter new password:
3，Remove anonymous users? [Y/n] y							是否删除匿名用户 
 ... Success!
4，Disallow root login remotely? [Y/n] n						是否拒绝root远程登录
 ... Success!
5，Remove test database and access to it? [Y/n] y    是否删除test数据库，test数据库一般不需要
  Dropping test database...
 ... Success!
  Removing privileges on test database...
 ... Success!
6，Reload privilege tables now? [Y/n] y				重新加载权限表
 ... Success!
>##四丶进入数据库并操作它
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/17/kuangstudy4d985cd1-c46c-4c97-8da9-16010b114ffc.png)
####导入数据库表
xx代表文件地址
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/17/kuangstudya5143348-9960-4b68-934d-a55d6fe25ebe.png)
####修改数据库远程链接权限
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudy712302be-4f87-433b-8943-05c6be1f00c1.png)
切换到mysql
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudy311de99d-182d-4e84-9f7b-2cd84fd1236a.png) 
查看表
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudyac4d4e20-3f8d-4cf4-a27f-473d44625e6a.png)
查询user表字段
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudybcd40ed5-43db-4bb6-8932-f3e1ebe9a0c3.png)
修改localhost字段
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudy9fbe6ccc-b323-4caa-9ae6-6e08c0446804.png)
刷新数据库权限
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudyf82c48cc-3ea8-4d88-a43f-3d7c18f50012.png)
####如Linux防火墙没有关闭则需打开mysql对应的端口
	[root@VM-0-16-centos ~]# firewall-cmd --add-port=3306/tcp     打开防火墙对应端口
	[root@VM-0-16-centos ~]# firewall-cmd --query-port=3306/tcp   查询是否开放
	
链接成功
![](https://kuangstudy.oss-cn-beijing.aliyuncs.com/bbs/2021/03/18/kuangstudyf334e43d-ed8c-4988-967c-00cb81d1c358.png)

------------

# 	卸载
```java
[root@VM-0-16-centos /]# rpm -qa |grep mariadb 
mariadb-server-5.5.68-1.el7.x86_64
mariadb-5.5.68-1.el7.x86_64
mariadb-libs-5.5.68-1.el7.x86_64

[root@VM-0-16-centos /]# yum remove mariadb
Loaded plugins: fastestmirror, langpacks
Resolving Dependencies

。。。。。此处省略。。。。。。

Removed:
  mariadb.x86_64 1:5.5.68-1.el7

Dependency Removed:
  mariadb-server.x86_64 1:5.5.68-1.el7

Complete!
```
###删除残留信息
```java
[root@VM-0-16-centos /]# ls /etc/my.cnf.d/
mysql-clients.cnf
[root@VM-0-16-centos /]# ll /var/lib/mysql/
total 28712
-rw-rw---- 1 mysql mysql    16384 Mar 18 10:22 aria_log.00000001
-rw-rw---- 1 mysql mysql       52 Mar 18 10:22 aria_log_control
-rw-rw---- 1 mysql mysql 18874368 Mar 18 10:22 ibdata1
-rw-rw---- 1 mysql mysql  5242880 Mar 18 10:22 ib_logfile0
-rw-rw---- 1 mysql mysql  5242880 Mar 17 15:36 ib_logfile1
drwx------ 2 mysql mysql     4096 Mar 17 15:36 mysql
drwx------ 2 mysql mysql     4096 Mar 17 15:36 performance_schema
-rw-rw---- 1 mysql mysql    10584 Mar 18 10:22 VM-0-16-centos.err
[root@VM-0-16-centos /]# rm -rf etc/my.cnf.d/
[root@VM-0-16-centos /]# rm -rf /var/lib/mysql/
```

MariaDB在liunx的安装和卸载

总共已有 0 条评论