centos7升级自带的mariadb数据库
#查看版本
[root@guangzhou local]# mysql --version
mysql Ver 173)">15.1 Distrib 5.5.64-MariaDB, for Linux (x86_64) using readline 5.1
#查看使用状态
[root@guangzhou local]# systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: active (running) since 三 2020-01-29 17:31:33 CST; 6 days ago
Main PID: 964 (mysqld_safe)
CGroup: /system.slice/mariadb.service
├─ 964 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
└─1249 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log -...
1月 29 17:31:29 guangzhou systemd[1]: Starting MariaDB database server...
1月 29 17:31:29 guangzhou mariadb-prepare-db-dir[870]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
1月 29 17:31:30 guangzhou mysqld_safe[964]: 200129 17:31:30 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
1月 29 17:31:30 guangzhou mysqld_safe[964]: 200129 17:31:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
1月 29 17:31:33 guangzhou systemd[1]: Started MariaDB database server.
#查看自带安装信息
[root@guangzhou local]# rpm -qa | grep -i mariadb
mariadb-5.5.64-1.el7.x86_64
mariadb-server-5.5.64-1.el7.x86_64
mariadb-libs-5.5.64-1.el7.x86_64
[root@guangzhou local]# yum list|grep mariadb
mariadb.x86_64 1:5.5.64-1.el7 @os
mariadb-libs.x86_64 1:5.5.64-1.el7 @os
mariadb-server.x86_64 1:5.5.64-1.el7 @os
mariadb-bench.x86_64 1:5.5.64-1.el7 os
mariadb-devel.i686 1:5.5.64-1.el7 os
mariadb-devel.x86_64 1:5.5.64-1.el7 os
mariadb-embedded.i686 1:5.5.64-1.el7 os
mariadb-embedded.x86_64 1:5.5.64-1.el7 os
mariadb-embedded-devel.i686 1:5.5.64-1.el7 os
mariadb-embedded-devel.x86_64 1:5.5.64-1.el7 os
mariadb-libs.i686 1:5.5.64-1.el7 os
mariadb-test.x86_64 1:5.5.64-1.el7 os#停止服务运行
[root@guangzhou local]# systemctl stop mariadb && systemctl status mariadb
● mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
Active: inactive (dead) since 三 2020-02-05 55 55 173)">173)">10:55:53 CST; 8ms ago
Process: 964 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Main PID: 964 (code=exited, status=0/SUCCESS)
1月 29 55 173)">17:55 173)">31:29 guangzhou systemd[1]: Starting MariaDB database server...
1月 29 55 173)">17:55 173)">31:29 guangzhou mariadb-prepare-db-dir[870]: Database MariaDB is probably initialized in /var/lib/mysql already, nothing is done.
1月 29 55 173)">17:55 173)">31:30 guangzhou mysqld_safe[964]: 200129 55 173)">17:55 173)">31:30 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.
1月 29 55 173)">17:55 173)">31:30 guangzhou mysqld_safe[964]: 200129 55 173)">17:55 173)">31:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
1月 29 55 173)">17:55 173)">31:33 guangzhou systemd[1]: Started MariaDB database server.
2月 05 55 55 173)">173)">10:55:50 guangzhou systemd[1]: Stopping MariaDB database server...
2月 05 55 55 173)">173)">10:55:53 guangzhou systemd[1]: Stopped MariaDB database server.#开始卸载
[root@guangzhou local]# yum remove -y mariadb && yum remove -y mariadb-*
...
#已搜不到安装信息
[root@guangzhou local]# yum list installed |grep mariadb
[root@guangzhou local]# rpm -qa|grep mariadb
[root@guangzhou local]# find / -name mysql
/var/lib/mysql
/usr/lib64/mysql
[root@guangzhou local]# rm -rf /var/lib/mysql/
[root@guangzhou local]# rm -rf /var/lib64/mysql/
[root@guangzhou local]# find / -name mariadb
/var/log/mariadb
[root@guangzhou local]# rm -rf /var/log/mariadb#配置yum源为国内地址
[root@guangzhou local]# vim /etc/yum.repos.d/Mariadb.repo
#录入以下内容
[mariadb]
name = MariaDB
baseurl = https://mirrors.ustc.edu.cn/mariadb/yum/10.2/centos7-amd64
gpgkey=https://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
#清除yum源缓存数据，并生成新的yum源数据缓存
[root@guangzhou local]# yum clean all && yum makecache all
...
#查看下载缓存信息
[root@guangzhou local]# ll /var/cache/yum/x86_64/7/mariadb
总用量 396
-rw-r--r-- 1 root root 54485 1月 28 02:57 6ee412270ec698aa4df35ba5cce163c7a253cd6421e25227cacc56e2e60c61bd-primary.sqlite.bz2
-rw-r--r-- 1 root root 10337 1月 28 02:57 a72c2fc88cd9a6a39f8eaa8649dae1ce968531dbfdae3a004536c2f1d4a4cfc4-other.sqlite.bz2
-rw-r--r-- 1 root root 0 2月 5 11:18 cachecookie
-rw-r--r-- 1 root root 305249 1月 28 02:57 fd747406618f18fd6d25d3589466d78cc3e31d2efcebf39a08da8cb58b80b619-filelists.sqlite.bz2
drwxr-xr-x 2 root root 4096 2月 5 11:19 gen
drwxr-xr-x 2 root root 4096 2月 5 11:18 packages
-rw-r--r-- 1 root root 2988 1月 28 02:57 repomd.xml#开始安装
[root@guangzhou local]# yum install MariaDB-server MariaDB-client -y
已加载插件：fastestmirror, langpacks
Loading mirror speeds from cached hostfile
正在解决依赖关系
--> 正在检查事务
---> 软件包 MariaDB-client.x86_64.0.255 173)">10.2.31-1.el7.centos 将被 安装
--> 正在处理依赖关系 MariaDB-common，它被软件包 MariaDB-client-255 173)">10.2.31-1.el7.centos.x86_64 需要
---> 软件包 MariaDB-server.x86_64.0.255 173)">10.2.31-1.el7.centos 将被 安装
--> 正在处理依赖关系 galera，它被软件包 MariaDB-server-255 173)">10.2.31-1.el7.centos.x86_64 需要
--> 正在检查事务
---> 软件包 MariaDB-common.x86_64.0.255 173)">10.2.31-1.el7.centos 将被 安装
--> 正在处理依赖关系 MariaDB-compat，它被软件包 MariaDB-common-255 173)">10.2.31-1.el7.centos.x86_64 需要
---> 软件包 galera.x86_64.0.25.3.28-1.rhel7.el7.centos 将被 安装
--> 正在处理依赖关系 libboost_program_options.so.1.53.0()(64bit)，它被软件包 galera-25.3.28-1.rhel7.el7.centos.x86_64 需要
--> 正在检查事务
---> 软件包 MariaDB-compat.x86_64.0.255 173)">10.2.31-1.el7.centos 将被 安装
---> 软件包 boost-program-options.x86_64.0.1.53.0-27.el7 将被 安装
--> 解决依赖关系完成
依赖关系解决
================================================================================================================================================================
Package 架构 版本 源 大小
================================================================================================================================================================
正在安装:
MariaDB-client x86_64 255 173)">10.2.31-1.el7.centos 06)">mariadb 11 M
MariaDB-server x86_64 255 173)">10.2.31-1.el7.centos 06)">mariadb 24 M
为依赖而安装:
MariaDB-common x86_64 255 173)">10.2.31-1.el7.centos 06)">mariadb 81 k
MariaDB-compat x86_64 255 173)">10.2.31-1.el7.centos 06)">mariadb 2.8 M
boost-program-options x86_64 1.53.0-27.el7 os 156 k
galera x86_64 25.3.28-1.rhel7.el7.centos 06)">mariadb 8.0 M
事务概要
================================================================================================================================================================
安装 2 软件包 (+4 依赖软件包)
总下载量：46 M
安装大小：196 M
Downloading packages:
警告：/var/cache/yum/x86_64/7/06)">mariadb/packages/MariaDB-common-255 173)">10.2.31-1.el7.centos.x86_64.rpm: 头V4 DSA/SHA1 Signature, 密钥 ID 1bb943db: NOKEYkB 00:06:29 ETA
MariaDB-common-255 173)">10.2.31-1.el7.centos.x86_64.rpm 的公钥尚未安装
(1/6): MariaDB-common-255 173)">10.2.31-1.el7.centos.x86_64.rpm | 81 kB 00:00:04
(2/6): MariaDB-compat-255 173)">10.2.31-1.el7.centos.x86_64.rpm | 2.8 MB 00:00:02
(3/6): boost-program-options-1.53.0-27.el7.x86_64.rpm | 156 kB 00:00:00
(4/6): MariaDB-client-255 173)">10.2.31-1.el7.centos.x86_64.rpm | 11 MB 00:00:11
(5/6): galera-25.3.28-1.rhel7.el7.centos.x86_64.rpm | 8.0 MB 00:00:02
(6/6): MariaDB-server-255 173)">10.2.31-1.el7.centos.x86_64.rpm | 24 MB 00:00:255 173)">10
----------------------------------------------------------------------------------------------------------------------------------------------------------------
总计 2.5 MB/s | 46 MB 00:00:17
从 https://06)">mirrors.ustc.edu.cn/06)">mariadb/yum/RPM-GPG-KEY-MariaDB 检索密钥
导入 GPG key 0x1BB943DB:
用户ID : "MariaDB Package Signing Key <package-signing-key@06)">mariadb.org>"
指纹 : 1993 69e5 404b d5fc 7d2f e43b cbcb 082a 1bb9 43db
来自 : https://06)">mirrors.ustc.edu.cn/06)">mariadb/yum/RPM-GPG-KEY-MariaDB
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
正在安装 : MariaDB-compat-255 173)">10.2.31-1.el7.centos.x86_64 1/6
正在安装 : MariaDB-common-255 173)">10.2.31-1.el7.centos.x86_64 2/6
正在安装 : MariaDB-client-255 173)">10.2.31-1.el7.centos.x86_64 3/6
正在安装 : boost-program-options-1.53.0-27.el7.x86_64 4/6
正在安装 : galera-25.3.28-1.rhel7.el7.centos.x86_64 5/6
正在安装 : MariaDB-server-255 173)">10.2.31-1.el7.centos.x86_64 6/6
PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:
'/usr/bin/mysqladmin' -u root password 'new-password'
'/usr/bin/mysqladmin' -u root -h guangzhou password 'new-password'
Alternatively you can run:
'/usr/bin/mysql_secure_installation'
which will also give you the option of removing the test
databases and anonymous user created by 06)">default. This is
strongly recommended for production 06)">servers.
See the MariaDB Knowledgebase at http://06)">mariadb.com/kb or the
MySQL manual for more instructions.
Please report any problems at http://06)">mariadb.org/jira
The latest information about MariaDB is available at http://06)">mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Consider joining MariaDB's strong and vibrant community:
https://06)">mariadb.org/get-involved/
验证中 : galera-25.3.28-1.rhel7.el7.centos.x86_64 1/6
验证中 : MariaDB-common-255 173)">10.2.31-1.el7.centos.x86_64 2/6
验证中 : MariaDB-server-255 173)">10.2.31-1.el7.centos.x86_64 3/6
验证中 : boost-program-options-1.53.0-27.el7.x86_64 4/6
验证中 : MariaDB-client-255 173)">10.2.31-1.el7.centos.x86_64 5/6
验证中 : MariaDB-compat-255 173)">10.2.31-1.el7.centos.x86_64 6/6
已安装:
MariaDB-client.x86_64 0:255 173)">10.2.31-1.el7.centos MariaDB-server.x86_64 0:255 173)">10.2.31-1.el7.centos
作为依赖被安装:
MariaDB-common.x86_64 0:255 173)">10.2.31-1.el7.centos MariaDB-compat.x86_64 0:255 173)">10.2.31-1.el7.centos boost-program-options.x86_64 0:1.53.0-27.el7
galera.x86_64 0:25.3.28-1.rhel7.el7.centos
完毕！#启动mariadb
[root@guangzhou local]# systemctl start mariadb.service
#初始化配置信息
[root@guangzhou local]# /usr/bin/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!
#安装完成
#运行
[root@guangzhou local]# mysql -h 127.0.0.1 -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 20
Server version: 10.2.31-MariaDB MariaDB Server
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>#查看mariadb运行状态
systemctl status mariadb
#启动mariadb
systemctl start mariadb
#停止mariadb
#重新启动
systemctl restart mariadb
#开机启动
systemctl enable mariadb本文来自博客园，作者：super_ip，转载请注明原文链接：https://www.cnblogs.com/superip/p/17245635.html
