centos 7下安装mysql（MariaDB）的教程

centos7安装MariaDB教程，分享给大家

1.centos7现状：

　　新系统无法再使用yum install mysql-server来安装mysql，因为已使用mariadb代替mysql。

2.安装mariadb：

[root@localhost ~]# yum -y install mariadb*
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirrors.linode.com
 * extras: mirrors.linode.com
 * updates: mirrors.linode.com
Resolving Dependencies
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-bench.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-devel.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-embedded.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-embedded-devel.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-libs.x86_64 1:5.5.37-1.el7_0 will be installed
---> Package mariadb-server.x86_64 1:5.5.37-1.el7_0 will be installed
--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.37-1.el7_0.x86_64
---> Package mariadb-test.x86_64 1:5.5.37-1.el7_0 will be installed
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==========================================================================================================
 Package              Arch       Version           Repository     Size
==========================================================================================================
Installing:
 mariadb              x86_64      1:5.5.37-1.el7_0      updates      8.9 M
 mariadb-bench           x86_64      1:5.5.37-1.el7_0      updates      385 k
 mariadb-devel           x86_64      1:5.5.37-1.el7_0      updates      744 k
 mariadb-embedded         x86_64      1:5.5.37-1.el7_0      updates      3.6 M
 mariadb-embedded-devel      x86_64      1:5.5.37-1.el7_0      updates      7.4 M
 mariadb-libs           x86_64      1:5.5.37-1.el7_0      updates      752 k
 mariadb-server          x86_64      1:5.5.37-1.el7_0      updates       11 M
 mariadb-test           x86_64      1:5.5.37-1.el7_0      updates      7.9 M
Installing for dependencies:
 perl-DBD-MySQL          x86_64      4.023-5.el7         base        140 k

Transaction Summary
==========================================================================================================
Install 8 Packages (+1 Dependent package)

Total download size: 40 M
Installed size: 279 M
Downloading packages:
(1/9): mariadb-bench-5.5.37-1.el7_0.x86_64.rpm                   | 385 kB 00:00:00
(2/9): mariadb-devel-5.5.37-1.el7_0.x86_64.rpm                   | 744 kB 00:00:00
(3/9): mariadb-embedded-5.5.37-1.el7_0.x86_64.rpm                 | 3.6 MB 00:00:00
(4/9): mariadb-5.5.37-1.el7_0.x86_64.rpm                      | 8.9 MB 00:00:00
(5/9): mariadb-libs-5.5.37-1.el7_0.x86_64.rpm                   | 752 kB 00:00:00
(6/9): mariadb-server-5.5.37-1.el7_0.x86_64.rpm                  | 11 MB 00:00:00
(7/9): mariadb-embedded-devel-5.5.37-1.el7_0.x86_64.rpm              | 7.4 MB 00:00:00
(8/9): mariadb-test-5.5.37-1.el7_0.x86_64.rpm                   | 7.9 MB 00:00:00
(9/9): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm                    | 140 kB 00:00:00
----------------------------------------------------------------------------------------------------------
Total                                   36 MB/s | 40 MB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : 1:mariadb-libs-5.5.37-1.el7_0.x86_64                          1/9
 Installing : 1:mariadb-5.5.37-1.el7_0.x86_64                            2/9
 Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                           3/9
 Installing : 1:mariadb-server-5.5.37-1.el7_0.x86_64                         4/9
 Installing : 1:mariadb-devel-5.5.37-1.el7_0.x86_64                         5/9
 Installing : 1:mariadb-embedded-5.5.37-1.el7_0.x86_64                        6/9
 Installing : 1:mariadb-embedded-devel-5.5.37-1.el7_0.x86_64                     7/9
 Installing : 1:mariadb-test-5.5.37-1.el7_0.x86_64                          8/9
 Installing : 1:mariadb-bench-5.5.37-1.el7_0.x86_64                         9/9
 Verifying : 1:mariadb-test-5.5.37-1.el7_0.x86_64                          1/9
 Verifying : 1:mariadb-embedded-devel-5.5.37-1.el7_0.x86_64                     2/9
 Verifying : 1:mariadb-embedded-5.5.37-1.el7_0.x86_64                        3/9
 Verifying : 1:mariadb-libs-5.5.37-1.el7_0.x86_64                          4/9
 Verifying : 1:mariadb-bench-5.5.37-1.el7_0.x86_64                         5/9
 Verifying : 1:mariadb-5.5.37-1.el7_0.x86_64                            6/9
 Verifying : 1:mariadb-server-5.5.37-1.el7_0.x86_64                         7/9
 Verifying : perl-DBD-MySQL-4.023-5.el7.x86_64                           8/9
 Verifying : 1:mariadb-devel-5.5.37-1.el7_0.x86_64                         9/9

Installed:
 mariadb.x86_64 1:5.5.37-1.el7_0            mariadb-bench.x86_64 1:5.5.37-1.el7_0
 mariadb-devel.x86_64 1:5.5.37-1.el7_0         mariadb-embedded.x86_64 1:5.5.37-1.el7_0
 mariadb-embedded-devel.x86_64 1:5.5.37-1.el7_0     mariadb-libs.x86_64 1:5.5.37-1.el7_0
 mariadb-server.x86_64 1:5.5.37-1.el7_0         mariadb-test.x86_64 1:5.5.37-1.el7_0

Dependency Installed:
 perl-DBD-MySQL.x86_64 0:4.023-5.el7

Complete!
[root@localhost ~]# systemctl start mariadb.service
[root@localhost ~]# systemctl enable mariadb.service
ln -s '/usr/lib/systemd/system/mariadb.service' '/etc/systemd/system/multi-user.target.wants/mariadb.servi           
ce'
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> logout
  -> exit
  ->
  -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaD           
B server version for the right syntax to use near 'logout
exit' at line 1
MariaDB [(none)]> exit
Bye
[root@localhost ~]# systemctl enable mariadb.service
[root@localhost ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database      |
+--------------------+
| information_schema |
| mysql       |
| performance_schema |
| test        |
+--------------------+
rows in set (0.00 sec)

MariaDB [(none)]> use test
Database changed
MariaDB [test]> show tables;
Empty set (0.00 sec)

MariaDB [test]> exit
Bye
[root@localhost ~]# mysql_secure_installation
/usr/bin/mysql_secure_installation: line 379: find_mysql_client: command not found

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.

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
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] y
 ... Success!

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@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 15
Server version: 5.5.37-MariaDB MariaDB Server

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database      |
+--------------------+
| information_schema |
| mysql       |
| performance_schema |
| zbphp.com     |
+--------------------+
rows in set (0.00 sec)

MariaDB [(none)]>

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。

# centos7  # mysql  # MariaDB  # centos 7安装mysql5.5和安装 mariadb使用的命令  # centos 下面安装python2.7 +pip +mysqld  # centos 7安装mysql5.5的方法  # CentOS 7中安装mysql server的步骤分享  # CentOS下PHP7的编译安装及MySQL的支持和一些常见问题的解决办法  # mysql 5.7.17 安装配置方法图文教程(CentOS7)  # 64位CentOs7源码安装mysql-5.6.35过程分享  # Centos6.5编译安装mysql 5.7.14详细教程  # CentOS7.2虚拟机上安装MySQL 5.6.32的教程  # Centos7下MySQL安装教程  # 给大家  # 大家多多  # Packages  # Total  # Dependent  # Install  # Transaction  # Summary  # Downloading 

相关文章： 如何在阿里云虚拟主机上快速搭建个人网站？  临沂网站制作企业,临沂第三中学官方网站？  网站建设设计制作营销公司南阳,如何策划设计和建设网站？  长春网站建设制作公司,长春的网络公司怎么样主要是能做网站的？  高端建站三要素：定制模板、企业官网与响应式设计优化  Swift中循环语句中的转移语句 break 和 continue  建站中国官网：模板定制+SEO优化+建站流程一站式指南  定制建站平台哪家好？企业官网搭建与快速建站方案推荐  制作销售网站教学视频,销售网站有哪些？  网站制作与设计教程,如何制作一个企业网站，建设网站的基本步骤有哪些？  网站制作的方法有哪些,如何将自己制作的网站发布到网上？  网站制作说明怎么写,简述网页设计的流程并说明原因？  如何在局域网内绑定自建网站域名？  如何用手机制作网站和网页,手机移动端的网站能制作成中英双语的吗？  如何通过二级域名建站提升品牌影响力？  小程序网站制作需要准备什么资料,如何制作小程序？  平台云上自主建站：模板化设计与智能工具打造高效网站  如何在IIS服务器上快速部署高效网站？  制作表格网站有哪些,线上表格怎么弄？  c# 服务器GC和工作站GC的区别和设置  制作农业网站的软件,比较好的农业网站推荐一下？  广州顶尖建站服务：企业官网建设与SEO优化一体化方案  完全自定义免费建站平台：主题模板在线生成一站式服务  黑客如何通过漏洞一步步攻陷网站服务器？  建站之星上传入口如何快速找到？  南京网站制作费用,南京远驱官方网站？  西安大型网站制作公司,西安招聘网站最好的是哪个？  专业网站制作服务公司,有哪些网站可以免费发布招聘信息？  建站之星CMS五站合一模板配置与SEO优化指南  魔毅自助建站系统：模板定制与SEO优化一键生成指南  如何在阿里云部署织梦网站？  专业企业网站设计制作公司,如何理解商贸企业的统一配送和分销网络建设？  东莞专业网站制作公司有哪些,东莞招聘网站哪个好？  C#如何在一个XML文件中查找并替换文本内容  已有域名如何免费搭建网站？  怀化网站制作公司,怀化新生儿上户网上办理流程？  宝盒自助建站智能生成技巧：SEO优化与关键词设置指南  如何快速生成ASP一键建站模板并优化安全性？  成都品牌网站制作公司,成都营业执照年报网上怎么办理？  如何规划企业建站流程的关键步骤？  如何快速建站并高效导出源代码？  重庆网站制作公司哪家好,重庆中考招生办官方网站？  如何用花生壳三步快速搭建专属网站？  如何选择适配移动端的WAP自助建站平台？  C++中引用和指针有什么区别？（代码说明）  如何使用Golang table-driven基准测试_多组数据测量函数效率  建站之星导航菜单设置与功能模块配置全攻略  实例解析Array和String方法  品牌网站制作公司有哪些,买正品品牌一般去哪个网站买？  如何配置支付宝与微信支付功能？