Mariadb数据库配置及管理

以下内容都在redhat7.0上练习

1 安装mariadb

[root@test ~]# yum install mariadb-server -y   ###安装mariadb
[root@test ~]# systemctl start mariadb           ##开启mariadb服务
 [root@test ~]# mysql             ##登陆
MariaDB [(none)]> quit   ##退出mariadb
具体代码块如下：


[root@test ~]# yum install mariadb-server -y
Loaded plugins: langpacks
rhel_dvd                                                 | 4.1 kB     00:00     
(1/2): rhel_dvd/group_gz                                   | 134 kB   00:00     
(2/2): rhel_dvd/primary_db                                 | 3.4 MB   00:00     
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.35-3.el7 will be installed
--> Processing Dependency: mariadb(x86-64) = 1:5.5.35-3.el7 for package: 1:mariadb-server-5.5.35-3.el7.x86_64
--> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.35-3.el7.x86_64
--> Processing Dependency: perl(Data::Dumper) for package: 1:mariadb-server-5.5.35-3.el7.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.35-3.el7.x86_64
--> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.35-3.el7.x86_64
--> Running transaction check
---> Package mariadb.x86_64 1:5.5.35-3.el7 will be installed
---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed
---> Package perl-DBI.x86_64 0:1.627-4.el7 will be installed
--> Processing Dependency: perl(RPC::PlClient) >= 0.2000 for package: perl-DBI-1.627-4.el7.x86_64
--> Processing Dependency: perl(RPC::PlServer) >= 0.2001 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(Compress::Zlib) 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(Net::Daemon::Test) 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::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 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-server              x86_64     1:5.5.35-3.el7       rhel_dvd      11 M
Installing for dependencies:
 mariadb                     x86_64     1:5.5.35-3.el7       rhel_dvd     8.9 M
 perl-Compress-Raw-Bzip2     x86_64     2.061-3.el7          rhel_dvd      32 k
 perl-Compress-Raw-Zlib      x86_64     1:2.061-4.el7        rhel_dvd      57 k
 perl-DBD-MySQL              x86_64     4.023-5.el7          rhel_dvd     140 k
 perl-DBI                    x86_64     1.627-4.el7          rhel_dvd     802 k
 perl-Data-Dumper            x86_64     2.145-3.el7          rhel_dvd      47 k
 perl-IO-Compress            noarch     2.061-2.el7          rhel_dvd     260 k
 perl-Net-Daemon             noarch     0.48-5.el7           rhel_dvd      51 k
 perl-PlRPC                  noarch     0.2020-14.el7        rhel_dvd      36 k

Transaction Summary
================================================================================
Install  1 Package (+9 Dependent packages)

Total download size: 21 M
Installed size: 107 M
Downloading packages:
(1/10): mariadb-5.5.35-3.el7.x86_64.rpm                    | 8.9 MB   00:00     
(2/10): mariadb-server-5.5.35-3.el7.x86_64.rpm             |  11 MB   00:00     
(3/10): perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64.rpm     |  32 kB   00:00     
(4/10): perl-Compress-Raw-Zlib-2.061-4.el7.x86_64.rpm      |  57 kB   00:00     
(5/10): perl-DBD-MySQL-4.023-5.el7.x86_64.rpm              | 140 kB   00:00     
(6/10): perl-Data-Dumper-2.145-3.el7.x86_64.rpm            |  47 kB   00:00     
(7/10): perl-DBI-1.627-4.el7.x86_64.rpm                    | 802 kB   00:00     
(8/10): perl-IO-Compress-2.061-2.el7.noarch.rpm            | 260 kB   00:00     
(9/10): perl-Net-Daemon-0.48-5.el7.noarch.rpm              |  51 kB   00:00     
(10/10): perl-PlRPC-0.2020-14.el7.noarch.rpm               |  36 kB   00:00     
--------------------------------------------------------------------------------
Total                                               29 MB/s |  21 MB  00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : perl-Data-Dumper-2.145-3.el7.x86_64                         1/10 
  Installing : 1:mariadb-5.5.35-3.el7.x86_64                               2/10 
  Installing : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                 3/10 
  Installing : perl-Net-Daemon-0.48-5.el7.noarch                           4/10 
  Installing : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                  5/10 
  Installing : perl-IO-Compress-2.061-2.el7.noarch                         6/10 
  Installing : perl-PlRPC-0.2020-14.el7.noarch                             7/10 
  Installing : perl-DBI-1.627-4.el7.x86_64                                 8/10 
  Installing : perl-DBD-MySQL-4.023-5.el7.x86_64                           9/10 
  Installing : 1:mariadb-server-5.5.35-3.el7.x86_64                       10/10 
  Verifying  : perl-Compress-Raw-Bzip2-2.061-3.el7.x86_64                  1/10 
  Verifying  : perl-Net-Daemon-0.48-5.el7.noarch                           2/10 
  Verifying  : perl-Data-Dumper-2.145-3.el7.x86_64                         3/10 
  Verifying  : perl-PlRPC-0.2020-14.el7.noarch                             4/10 
  Verifying  : 1:perl-Compress-Raw-Zlib-2.061-4.el7.x86_64                 5/10 
  Verifying  : 1:mariadb-server-5.5.35-3.el7.x86_64                        6/10 
  Verifying  : perl-DBI-1.627-4.el7.x86_64                                 7/10 
  Verifying  : 1:mariadb-5.5.35-3.el7.x86_64                               8/10 
  Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                           9/10 
  Verifying  : perl-IO-Compress-2.061-2.el7.noarch                        10/10 

Installed:
  mariadb-server.x86_64 1:5.5.35-3.el7                                          

Dependency Installed:
  mariadb.x86_64 1:5.5.35-3.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-5.el7                                           
  perl-DBI.x86_64 0:1.627-4.el7