centos 7 安装mysql遇到的问题

95 阅读 0 评论 63 点赞

我是靠谱客的博主舒心饼干，最近开发中收集的这篇文章主要介绍centos 7 安装mysql遇到的问题，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

cent os 7安装mysql遇到的问题

1.在centos 7上装mysql，但是运行的话会报错，服务未启动

[evilrat@evilRat_desktop ~]$ mysql status
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

2.尝试启动服务：

[evilrat@evilRat_desktop ~]$ systemctl enable mysql.service
Failed to execute operation: Access denied

这样也不行……

[evilrat@evilRat_desktop ~]$ service mysql start
Redirecting to /bin/systemctl start  mysql.service

3.通过百度找到这个
mariaDB

MariaDB数据库管理系统是MySQL的一个分支，主要由开源社区在维护，采用GPL授权许可 MariaDB的目的是完全兼容MySQL，包括API和命令行，使之能轻松成为MySQL的代替品。在存储引擎方面，使用XtraDB（英语：XtraDB）来代替MySQL的InnoDB。 MariaDB由MySQL的创始人Michael Widenius（英语：Michael Widenius）主导开发，他早前曾以10亿美元的价格，将自己创建的公司MySQL AB卖给了SUN，此后，随着SUN被甲骨文收购，MySQL的所有权也落入Oracle的手中。MariaDB名称来自Michael Widenius的女儿Maria的名字。
MariaDB基于事务的Maria存储引擎，替换了MySQL的MyISAM存储引擎，它使用了Percona的 XtraDB，InnoDB的变体，分支的开发者希望提供访问即将到来的MySQL 5.4 InnoDB性能。这个版本还包括了 PrimeBase XT (PBXT) 和 FederatedX存储引擎。

4.于是我尝试安装了一下

[root@evilRat_desktop evilrat]# yum install mariadb-server -y
Loaded plugins: fastestmirror, langpacks
Repository epel is listed more than once in the configuration
Repository epel-debuginfo is listed more than once in the configuration
Repository epel-source is listed more than once in the configuration
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
adobe-linux-x86_64                                       |  951 B     00:00     
base                                                     | 3.6 kB     00:00     
epel                                                     | 4.3 kB     00:00     
extras                                                   | 3.4 kB     00:00     
nux-dextop                                               | 2.9 kB     00:00     
updates                                                  | 3.4 kB     00:00     
(1/5): extras/7/x86_64/primary_db                          | 139 kB   00:00     
(2/5): epel/x86_64/updateinfo                              | 765 kB   00:01     
(3/5): epel/x86_64/primary_db                              | 4.6 MB   00:10     
(4/5): updates/7/x86_64/primary_db                         | 3.8 MB   00:11     
(5/5): nux-dextop/x86_64/primary_db                        | 1.7 MB   00:29     
adobe-linux-x86_64/primary                                 | 1.3 kB   00:00     
Loading mirror speeds from cached hostfile
 * base: mirrors.aliyun.com
 * epel: mirrors.aliyun.com
 * extras: mirrors.aliyun.com
 * nux-dextop: li.nux.ro
 * updates: mirrors.aliyun.com
adobe-linux-x86_64                                                          3/3
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be installed
--> Processing Dependency: perl-DBI for package: 1:mariadb-server-5.5.52-1.el7.x86_64
--> Processing Dependency: perl-DBD-MySQL for package: 1:mariadb-server-5.5.52-1.el7.x86_64
--> Processing Dependency: perl(DBI) for package: 1:mariadb-server-5.5.52-1.el7.x86_64
--> Running transaction check
---> 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::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
--> 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-server               x86_64      1:5.5.52-1.el7        base       11 M
Installing for dependencies:
 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-5.el7           base      140 k
 perl-DBI                     x86_64      1.627-4.el7           base      802 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  1 Package (+7 Dependent packages)

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

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

Dependency Installed:
  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                                                 
  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!

5.然后我启动服务，尝试启动mysql

[root@evilRat_desktop evilrat]# systemctl start mariadb.service
[root@evilRat_desktop evilrat]# systemctl enable mariadb.service
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.
[root@evilRat_desktop evilrat]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 2
Server version: 5.5.52-MariaDB MariaDB Server

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation 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               |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> exit
Bye