centos 7 安装 mariadb

最新推荐文章于 2024-05-24 20:07:42 发布
最新推荐文章于 2024-05-24 20:07:42 发布
阅读量373 收藏
点赞数
分类专栏： mysql 文章标签： mariadb
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xu990128638/article/details/113578466
版权

 


[root@c7 conf]# systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@c7 conf]# cp /usr/share/mysql/my-huge.cnf  /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? y
[root@c7 conf]# vim /etc/my.cnf
[root@c7 conf]# systemctl start mariadb.service

 

[root@c7 conf]# yum install mariadb mariadb-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
epel/x86_64/metalink                                                                                                                             | 9.4 kB  00:00:00
 * base: mirrors.aliyun.com
 * epel: mirrors.tuna.tsinghua.edu.cn
 * extras: mirrors.aliyun.com
 * updates: mirrors.aliyun.com
base                                                                                                                                             | 3.6 kB  00:00:00
docker-ce-stable                                                                                                                                 | 3.5 kB  00:00:00
extras                                                                                                                                           | 2.9 kB  00:00:00
updates                                                                                                                                          | 2.9 kB  00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.68-1.el7 will be installed
---> Package mariadb-server.x86_64 1:5.5.68-1.el7 will be installed
--> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.4)(64bit) for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Processing Dependency: libaio.so.1(LIBAIO_0.1)(64bit) for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Processing Dependency: libaio.so.1()(64bit) for package: 1:mariadb-server-5.5.68-1.el7.x86_64
--> Running transaction check
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package perl-DBD-MySQL.x86_64 0:4.023-6.el7 will be installed
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
---> Package perl-Data-Dumper.x86_64 0:2.145-3.el7 will be installed
--> Running transaction check
---> Package perl-PlRPC.noarch 0:0.2020-14.el7 will be installed
--> Processing Dependency: perl(Net::Daemon) >= 0.13 for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Test) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Net::Daemon::Log) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Processing Dependency: perl(Compress::Zlib) for package: perl-PlRPC-0.2020-14.el7.noarch
--> Running transaction check
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
--> Running transaction check
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

======================================================================================================================================================================== Package                                            Arch                              Version                                     Repository                       Size
========================================================================================================================================================================Installing:
 mariadb                                            x86_64                            1:5.5.68-1.el7                              base                            8.8 M
 mariadb-server                                     x86_64                            1:5.5.68-1.el7                              base                             11 M
Installing for dependencies:
 libaio                                             x86_64                            0.3.109-13.el7                              base                             24 k
 perl-Compress-Raw-Bzip2                            x86_64                            2.061-3.el7                                 base                             32 k
 perl-Compress-Raw-Zlib                             x86_64                            1:2.061-4.el7                               base                             57 k
 perl-DBD-MySQL                                     x86_64                            4.023-6.el7                                 base                            140 k
 perl-DBI                                           x86_64                            1.627-4.el7                                 base                            802 k
 perl-Data-Dumper                                   x86_64                            2.145-3.el7                                 base                             47 k
 perl-IO-Compress                                   noarch                            2.061-2.el7                                 base                            260 k
 perl-Net-Daemon                                    noarch                            0.48-5.el7                                  base                             51 k
 perl-PlRPC                                         noarch                            0.2020-14.el7                               base                             36 k

Transaction Summary
========================================================================================================================================================================Install  2 Packages (+9 Dependent packages)

Total download size: 21 M
Installed size: 110 M
Is this ok [y/d/N]: y
Downloading packages:
(1/11): libaio-0.3.109-13.el7.x86_64.rpm                                                                                                         |  24 kB  00:00:00
(2/11): mariadb-server-5.5.68-1.el7.x86_64.rpm                                                                                                   |  11 MB  00:00:01
(3/11): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm                                                                                           |  32 kB  00:00:06
(4/11): mariadb-5.5.68-1.el7.x86_64.rpm                                                                                                          | 8.8 MB  00:00:15
(5/11): perl-DBD-MySQL-4.023-6.el7.x86_64.rpm                                                                                                    | 140 kB  00:00:00
(6/11): perl-DBI-1.627-4.el7.x86_64.rpm                                                                                                          | 802 kB  00:00:00
(7/11): perl-Data-Dumper-2.145-3.el7.x86_64.rpm                                                                                                  |  47 kB  00:00:00
(8/11): perl-IO-Compress-2.061-2.el7.noarch.rpm                                                                                                  | 260 kB  00:00:01
(9/11): perl-Net-Daemon-0.48-5.el7.noarch.rpm                                                                                                    |  51 kB  00:00:00
(10/11): perl-PlRPC-0.2020-14.el7.noarch.rpm                                                                                                     |  36 kB  00:00:00
(11/11): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm                                                                                           |  57 kB  00:00:10
------------------------------------------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                                                   1.1 MB/s |  21 MB  00:00:19
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                 1/11
  Installing : libaio-0.3.109-13.el7.x86_64                                                                                                                        2/11
  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                         3/11
  Installing : 1:mariadb-5.5.68-1.el7.x86_64                                                                                                                       4/11
  Installing : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                   5/11
  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                          6/11
  Installing : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                 7/11
  Installing : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                     8/11
  Installing : perl-DBI-1.627-4.el7.x86_64                                                                                                                         9/11
  Installing : perl-DBD-MySQL-4.023-6.el7.x86_64                                                                                                                  10/11
  Installing : 1:mariadb-server-5.5.68-1.el7.x86_64                                                                                                               11/11
  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                                                                                                          1/11
  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                                                                                                                   2/11
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                                                                                                                 3/11
  Verifying  : 1:mariadb-server-5.5.68-1.el7.x86_64                                                                                                                4/11
  Verifying  : perl-DBD-MySQL-4.023-6.el7.x86_64                                                                                                                   5/11
  Verifying  : 1:mariadb-5.5.68-1.el7.x86_64                                                                                                                       6/11
  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                                                                                                         7/11
  Verifying  : perl-DBI-1.627-4.el7.x86_64                                                                                                                         8/11
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                                                                                        9/11
  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                                                                                                                    10/11
  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                                                                                                                11/11

Installed:
  mariadb.x86_64 1:5.5.68-1.el7                                                   mariadb-server.x86_64 1:5.5.68-1.el7

Dependency Installed:
  libaio.x86_64 0:0.3.109-13.el7      perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7   perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7   perl-DBD-MySQL.x86_64 0:4.023-6.el7
  perl-DBI.x86_64 0:1.627-4.el7       perl-Data-Dumper.x86_64 0:2.145-3.el7          perl-IO-Compress.noarch 0:2.061-2.el7         perl-Net-Daemon.noarch 0:0.48-5.el7
  perl-PlRPC.noarch 0:0.2020-14.el7

Complete!
[root@c7 conf]# vim /etc/my.cnf
[root@c7 conf]#
[root@c7 conf]# systemctl start mariadb.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
[root@c7 conf]# cp /usr/share/mysql/my-huge.cnf  /etc/my.cnf
cp: overwrite ‘/etc/my.cnf’? y
[root@c7 conf]# vim /etc/my.cnf
[root@c7 conf]# systemctl start mariadb.service
[root@c7 conf]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.68-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)]> show variables like  '%character_set%' ;
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

MariaDB [(none)]> quit;
Bye

 

潇凝子潇
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
MySQL单机部署
Zhuge_Dan的博客
06-28 1418
MySQL单机部署
centos7 安装mariadb
m0_55070913的博客
07-29 1252
MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可。MariaDB目的是完全兼容MySQL，包括API和命令行，她们有相同的命令、界面，以及在MySQL中的库与API，所以MariaDB可以说是为替换MySQL量身定做的，换用后连数据库都不必转换！并可以获得MariaDB提供的许多更好的。最近Oracle进一步闭源的举措更是让人难以安心，众多互联网公司纷纷开始寻求MySQL的替代方案。...
Centos7最小化安装缺少libaio
最新发布
weixin_45881557的博客
05-24 169
linux上用rpm安装 mysql-community-server-5.7.23-1.el7.x86_64.rpm提示缺少依赖。下载完后就可以使用下面的命令安装了。
libaio-0.3.109-13.el7.x86_64.rpm.rar
05-06
安装数据库的时候报缺少这个了，在目录下执行rpm -ivh libaio-0.3.109-13.el7.x86_64.rpm即可解决
centos7下离线安装MySQL5.7
qq_38220334的博客
03-16 8634
业务背景：公司中实际开发的时候，生产环境一般都是不连外网的，所以安装软件的时候都是离线安装，所以我试了好些方法，这种是操作比较简单的 第一步：卸载centos7中自带的MySQL centos7中是有自带MySQL数据库的，我们首先得先卸载它 先查看是否有自带的数据库：rpm -qa | grep mariadb 显示如下；mariadb-libs-5.5.44-2.el7.centos.x86_...
linux centos yum 报错 [Errno 256] No more mirrors to try 解决方法
whatday的专栏
11-03 1万+
目录 背景 报错信息 解决方案大致有三种 一、更新yum 二、若不行，可能是因为DNS不稳定吧，因为yum安装时会从三个”repo源“（base，extras，updates）随机获取地址 三、分析总结法 验证 背景 我使用yum方式安装软件时，比如zabbix这种软件，我们在安装时一般都是直接到zabbix官网，按照官方的步骤进行安装，但是有一个问题，官方的服务器不在国内，时常会在安装时导致超时报错。此时解决思路就因该是将官方源替换成国内的镜像源，例如阿里云、163的镜像源。要点就是网络
CentOS7 Error downloading packages 解决办法
热门推荐
段占彪的博客
04-16 7万+
问题描述 yum 在线安装一直没有问题，但是今天安装wget时报如下错误： Error downloading packages: wget-1.14-18.el7.x86_64: [Errno 256] No more mirrors to try. 原因 yum属于在线安装，及联网获取安装包，如果安装失败的话，一般和网络脱不了关系。 通过ping www.baidu.com 来检测网络...
CentOS7安装MariaDB
11-07
CentOS7 安装 MariaDB 并配置用户权限 CentOS7 安装 MariaDB 并添加配置用户等权限是 Linux 服务器管理中的一项重要任务。下面将详细介绍安装 MariaDB 的步骤、配置数据库字符集、创建用户并赋予权限等知识点。 ...
详解CentOS7 安装 MariaDB 10.2.4的方法
01-20
CentOS 6 及之前的版本中提供的是 MySQL 的服务器/客户端安装包，但 CentOS 7 已使用了 MariaDB 替代了默认的 MySQL。MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可 MariaDB的...
libaio-0.3.109-13.el7.x86_64.zip
06-28
相关博客： 《MySQL单机部署》： https://blog.csdn.net/Zhuge_Dan/article/details/106995554 《MySQL集群方案》： https://blog.csdn.net/Zhuge_Dan/article/details/108339965
(34条消息) CentOS 7 安装mariadb_centos7安装mariadb_托塔雨天王的博客-CSDN博客.mhtml
06-29
(34条消息) CentOS 7 安装mariadb_centos7安装mariadb_托塔雨天王的博客-CSDN博客.mhtml
CentOS7安装MariaDB+PYPY
09-27
包含本人在CentOS7上亲自安装MariaDB的图文流程，最后附加PYPY的安装
yum [Errno 256] No more mirrors to try 解决方法
luojinbai的专栏
03-06 1万+
转载自： http://blog.sina.com.cn/s/blog_6e0c0fdf01019onq.html 我的在安装systemtap时候出现这问题。 输入下面的命令即可解决问题： yum clean all yum makecache [root@localhost yum]# yum update Loaded plugins: fastest
linux7 安装错误256,CentOS7软件安装错误汇总
weixin_42460407的博客
05-12 1136
一、centos yum安装docker是报错报错信息：Error downloading packages:python-IPy-0.75-6.el7.noarch: [Errno 256] No more mirrors to try.libsemanage-python-2.5-14.el7.x86_64: [Errno 256] No more mirrors to try.policyc...
yum安装报错:[Errno 256] No more mirrors to try.
PPlluuttoo的博客
04-16 7125
Error downloading packages: zabbix-web-4.4.4-1.el7.noarch: [Errno 256] No more mirrors to try. zabbix-server-mysql-4.4.4-1.el7.x86_64: [Errno 256] No more mirrors to try. zabbix-agent-4.4.4-1.el7.x86_64: [Errno 256] No more mirrors to try. 方法一、更新y...
yum安装出现Error downloading packages错误及解决方法
lqh_linux的博客
10-14 2万+
一.问题出现 # yum -y install git 显示： Error downloading packages 清理yum缓存和建立yum缓存后，还是不行 # yum clean all # yum makecache 二.解决方法 查看日志/var/log/yum.log，但只显示错误结果，原因查不到。 所以还是直接把yum和python重新安装一遍 参考：https://blog.csdn.net/qq_36653942/article/details/80712088 1.卸载python
centos 7 mysql5.7 离线安装
huijieshizhu0的博客
03-24 625
环境准备 centos版本：centos 7 mysql版本： mysql5.7 1、下载安装包 下载mysql : https://dev.mysql.com/downloads/mysql/5.7.html#downloads 下载libaio1库 https://centos.pkgs.org/7/centos-x86_64/libaio...
展示表结构 show create table + 表名
xu990128638的专栏
01-04 5万+
    展示ddl CREATE TABLE `crm_dictionary` (   `id` bigint(20) NOT NULL AUTO_INCREMENT,   `code` int(16) NOT NULL,   `value` varchar(256) NOT NULL,   `type` varchar(32) NOT NULL,   `remark` varchar(...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

潇凝子潇

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值