Linux（centos 7.5）服务器安装MariaDB

r囧r小猫 2023-10-02 12:31 36阅读 0赞

### 1、查看Linux系统自带 mariadb ###

rpm -qa | grep -i mariadb

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center]

### 2、安装mariadb ###

yum install mariadb-server -y

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 1]

### 3、启动 ###

systemctl start mariadb

### 4、查看启动状态 ###

systemctl status mariadb

### 5、登录数据库 ###

mysql -uroot -p

没有密码，直接Enter进入既可。

### 6、设置密码 ###

SET PASSWORD = PASSWORD('123456');

### 7、为用户添加所有权限（远程登录，增删改） ###

grant all privileges on *.* to 'root' @'%' identified by '123456';

### 8、刷新权限 ###

flush privileges;

### 9、退出MySQL ###

exit

### 10、客户端连接MariaDB ###

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 2]

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 3]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center]: https://img-blog.csdnimg.cn/3831c2caac2248988376fcd203f63c33.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBAaGFfbHlkbXM=,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 1]: https://img-blog.csdnimg.cn/54e2885a41ca463eb7d93bfe476bd976.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBAaGFfbHlkbXM=,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 2]: https://img-blog.csdnimg.cn/d81e19185b0e4b1b9910b06c114983a9.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBAaGFfbHlkbXM=,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBAaGFfbHlkbXM_size_20_color_FFFFFF_t_70_g_se_x_16_pic_center 3]: https://img-blog.csdnimg.cn/b7ab2e2a781b491aaaf3a5f9f4a8c436.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBAaGFfbHlkbXM=,size_20,color_FFFFFF,t_70,g_se,x_16#pic_center