MariaDB(MySQL)安装

最新推荐文章于 2022-07-23 17:45:37 发布

徒手劈西瓜

最新推荐文章于 2022-07-23 17:45:37 发布

阅读量143

点赞数

分类专栏： Linux MySQL

本文链接：https://blog.csdn.net/w819104246/article/details/103560594

版权

Linux 同时被 2 个专栏收录

8 篇文章 0 订阅

订阅专栏

MySQL

5 篇文章 0 订阅

订阅专栏

前言

MySQL和Mariadb的区别
- MariaDB仅仅是MySQL的一个分支，主要是由开源社区维护，因此MariaDB是开源的，二者完全兼容，包括API和命令行，由于CentOS7内置的就是MariaDB，因此出一篇关于安装MariaDB的博客。

MariaDB安装流程

一.添加MariaDB的yum仓库

这里建议从官方下载MariaDB，因此导入官方的yum库

编辑创建MariaDB的仓库

vi /etc/yum.repos.d/MariaDB.repo

添加yum仓库的配置信息

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
# 建议大家选用下面的yum配置，选用的国内的源下载超级快，上面的下载了一夜。。
[mariadb]
name = MariaDB
baseurl = http://mirrors.ustc.edu.cn/mariadb/yum/10.3/centos7-amd64/
gpgkey=http://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1

在这里插入图片描述

二.安装MariaDB

可以使用以下命令直接进行安装

yum install MariaDB-server MariaDB-client -y

坑

执行到这里也许会报错，错误内容大概是与其它数据库冲突这里需要将以前安装过的数据库彻底删除干净，大家可以参考
如何彻底删除Mysql文件
对服务进行相关操作的命令

mariadb数据库的相关命令是：
systemctl start mariadb  #启动MariaDB
systemctl stop mariadb  #停止MariaDB
systemctl restart mariadb  #重启MariaDB
systemctl enable mariadb  #设置开机启动

三.初始化MariaDB

在生产环境中数据库安装好之后一般都不会直接使用，为了保证数据库安全稳定，首先会对数据库进行一次初始化，初始化包括以下五个方面

systemctl start mariadb #启动数据库
mysql_secure_installation #初始化命令

验证当前数据库的密码值，这里的密码值一般为空，可以直接回车
设置root管理员在数据库中的专有密码
删除匿名用户，并使用户可以远程连接数据库
删除默认测试数据库，取消测试数据库的一系列访问权限
刷新数据库设置，使初始化生效

[root@VM_0_14_centos /]# mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current
password for the root user.  If you've just installed MariaDB, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.

Enter current password for root (enter for none): 
OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MariaDB
root user without the proper authorisation.

Set root password? [Y/n] y
New password: 
Re-enter new password: 
Password updated successfully!
Reloading privilege tables..
 ... Success!


By default, a MariaDB installation has an anonymous user, allowing anyone
to log into MariaDB without having to have a user account created for
them.  This is intended only for testing, and to make the installation
go a bit smoother.  You should remove them before moving into a
production environment.

Remove anonymous users? [Y/n] y
 ... Success!

Normally, root should only be allowed to connect from 'localhost'.  This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] n
 ... skipping.

By default, MariaDB comes with a database named 'test' that anyone can
access.  This is also intended only for testing, and should be removed
before moving into a production environment.

Remove test database and access to it? [Y/n] y
 - Dropping test database...
 ... Success!
 - Removing privileges on test database...
 ... Success!

Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.

Reload privilege tables now? [Y/n] y
 ... Success!

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB
installation should now be secure.

Thanks for using MariaDB!

接下来就可以通过mysql -u root -p进入mysql了，具体命令参照我的Mysql博客
https://blog.csdn.net/w819104246/article/details/103482976