Centos7安装MySQL

来源:互联网 发布:云计算的概念? 编辑:程序博客网 时间:2024/06/03 12:38

MariaDB数据库管理系统是MySQL的一个分支,主要由开源社区在维护,采用GPL授权许可;
MariaDB的目的是完全兼容MySQL,包括API和命令行,使之能轻松成为MySQL的代替品。

Centos7默认安装mariadb,所以yum install -y mysql*时安装的就不是MySQL了。
那么如何实现安装MySQL而非Mariadb呢?

  1. 卸载mariadb

列出所有被安装的rpm package

[root@localhost install]# rpm -qa | grep mariadbmariadb-libs-5.5.52-1.el7.x86_64mariadb-5.5.52-1.el7.x86_64mariadb-bench-5.5.52-1.el7.x86_64mariadb-devel-5.5.52-1.el7.x86_64mariadb-embedded-devel-5.5.52-1.el7.x86_64mariadb-embedded-5.5.52-1.el7.x86_64mariadb-server-5.5.52-1.el7.x86_64mariadb-test-5.5.52-1.el7.x86_64

卸载

[root@localhost install]# yum -y remove mariadb*Loaded plugins: fastestmirror, langpacksResolving Dependencies--> Running transaction check---> Package mariadb.x86_64 1:5.5.52-1.el7 will be erased---> Package mariadb-bench.x86_64 1:5.5.52-1.el7 will be erased---> Package mariadb-devel.x86_64 1:5.5.52-1.el7 will be erased---> Package mariadb-embedded.x86_64 1:5.5.52-1.el7 will be erased---> Package mariadb-embedded-devel.x86_64 1:5.5.52-1.el7 will be erased---> Package mariadb-libs.x86_64 1:5.5.52-1.el7 will be erased--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: perl-DBD-MySQL-4.023-5.el7.x86_64--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-6.el7.x86_64---> Package mariadb-server.x86_64 1:5.5.52-1.el7 will be erased---> Package mariadb-test.x86_64 1:5.5.52-1.el7 will be erased--> Running transaction check---> Package perl-DBD-MySQL.x86_64 0:4.023-5.el7 will be erased---> Package postfix.x86_64 2:2.10.1-6.el7 will be erased--> Finished Dependency ResolutionDependencies Resolved=================================================================================================================== Package                             Arch                Version                      Repository              Size===================================================================================================================Removing: mariadb                             x86_64              1:5.5.52-1.el7               @base                   48 M mariadb-bench                       x86_64              1:5.5.52-1.el7               @base                  2.6 M mariadb-devel                       x86_64              1:5.5.52-1.el7               @base                  3.3 M mariadb-embedded                    x86_64              1:5.5.52-1.el7               @base                   14 M mariadb-embedded-devel              x86_64              1:5.5.52-1.el7               @base                   27 M mariadb-libs                        x86_64              1:5.5.52-1.el7               @anaconda              4.4 M mariadb-server                      x86_64              1:5.5.52-1.el7               @base                   56 M mariadb-test                        x86_64              1:5.5.52-1.el7               @base                  124 MRemoving for dependencies: perl-DBD-MySQL                      x86_64              4.023-5.el7                  @base                  323 k postfix                             x86_64              2:2.10.1-6.el7               @anaconda               12 MTransaction Summary===================================================================================================================Remove  8 Packages (+2 Dependent packages)Installed size: 292 MDownloading packages:Running transaction checkRunning transaction testTransaction test succeededRunning transaction  Erasing    : 1:mariadb-embedded-devel-5.5.52-1.el7.x86_64                                                   1/10   Erasing    : 1:mariadb-test-5.5.52-1.el7.x86_64                                                             2/10   Erasing    : 1:mariadb-devel-5.5.52-1.el7.x86_64                                                            3/10   Erasing    : 1:mariadb-bench-5.5.52-1.el7.x86_64                                                            4/10   Erasing    : 1:mariadb-server-5.5.52-1.el7.x86_64                                                           5/10 warning: /var/log/mariadb/mariadb.log saved as /var/log/mariadb/mariadb.log.rpmsave  Erasing    : 1:mariadb-5.5.52-1.el7.x86_64                                                                  6/10   Erasing    : perl-DBD-MySQL-4.023-5.el7.x86_64                                                              7/10   Erasing    : 2:postfix-2.10.1-6.el7.x86_64                                                                  8/10   Erasing    : 1:mariadb-libs-5.5.52-1.el7.x86_64                                                             9/10   Erasing    : 1:mariadb-embedded-5.5.52-1.el7.x86_64                                                        10/10   Verifying  : 1:mariadb-test-5.5.52-1.el7.x86_64                                                             1/10   Verifying  : 1:mariadb-5.5.52-1.el7.x86_64                                                                  2/10   Verifying  : 1:mariadb-embedded-devel-5.5.52-1.el7.x86_64                                                   3/10   Verifying  : 1:mariadb-server-5.5.52-1.el7.x86_64                                                           4/10   Verifying  : 1:mariadb-libs-5.5.52-1.el7.x86_64                                                             5/10   Verifying  : 1:mariadb-devel-5.5.52-1.el7.x86_64                                                            6/10   Verifying  : 1:mariadb-bench-5.5.52-1.el7.x86_64                                                            7/10   Verifying  : 2:postfix-2.10.1-6.el7.x86_64                                                                  8/10   Verifying  : perl-DBD-MySQL-4.023-5.el7.x86_64                                                              9/10   Verifying  : 1:mariadb-embedded-5.5.52-1.el7.x86_64                                                        10/10 Removed:  mariadb.x86_64 1:5.5.52-1.el7                               mariadb-bench.x86_64 1:5.5.52-1.el7                    mariadb-devel.x86_64 1:5.5.52-1.el7                         mariadb-embedded.x86_64 1:5.5.52-1.el7                 mariadb-embedded-devel.x86_64 1:5.5.52-1.el7                mariadb-libs.x86_64 1:5.5.52-1.el7                     mariadb-server.x86_64 1:5.5.52-1.el7                        mariadb-test.x86_64 1:5.5.52-1.el7                   Dependency Removed:  perl-DBD-MySQL.x86_64 0:4.023-5.el7                         postfix.x86_64 2:2.10.1-6.el7                        Complete!

2.安装MySQL
先安装带有当前可用的mysql5系列社区版资源的rpm包:

[root@localhost /]# rpm -Uvh http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmRetrieving http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpmPreparing...                          ################################# [100%]Updating / installing...   1:mysql-community-release-el7-5    ################################# [100%]

再查看当前可用的mysql安装资源:

[root@localhost /]# yum repolist enabled | grep "mysql.*-community.*"mysql-connectors-community/x86_64       MySQL Connectors Community           36mysql-tools-community/x86_64            MySQL Tools Community                47mysql56-community/x86_64                MySQL 5.6 Community Server          327

直接用yum方式安装了MySQL5.6版本了:

[root@localhost /]# yum -y install mysql-community-serverLoaded plugins: fastestmirror, langpacksLoading mirror speeds from cached hostfile * base: mirrors.btte.net * extras: mirrors.btte.net * updates: mirrors.163.com......Dependencies Resolved=============================================================================================================================================================================================== Package                                              Arch                                 Version                                       Repository                                       Size===============================================================================================================================================================================================Installing: mysql-community-server                               x86_64                               5.6.36-2.el7                                  mysql56-community                                59 MInstalling for dependencies: mysql-community-client                               x86_64                               5.6.36-2.el7                                  mysql56-community                                19 M mysql-community-common                               x86_64                               5.6.36-2.el7                                  mysql56-community                               257 k mysql-community-libs                                 x86_64                               5.6.36-2.el7                                  mysql56-community                               2.0 MTransaction Summary===============================================================================================================================================================================================Install  1 Package (+3 Dependent packages)Total download size: 81 MInstalled size: 351 MDownloading packages:warning: /var/cache/yum/x86_64/7/mysql56-community/packages/mysql-community-common-5.6.36-2.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY0.0 B/s |    0 B  --:--:-- ETA Public key for mysql-community-common-5.6.36-2.el7.x86_64.rpm is not installed(1/4): mysql-community-common-5.6.36-2.el7.x86_64.rpm                                                                                                                   | 257 kB  00:00:00     (2/4): mysql-community-libs-5.6.36-2.el7.x86_64.rpm                                                                                                                     | 2.0 MB  00:00:04     (3/4): mysql-community-client-5.6.36-2.el7.x86_64.rpm                                                                                                                   |  19 MB  00:01:19     (4/4): mysql-community-server-5.6.36-2.el7.x86_64.rpm                                                                                                                   |  59 MB  00:02:06     -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Total                                                                                                                                                          632 kB/s |  81 MB  00:02:11     R......  Installing : mysql-community-common-5.6.36-2.el7.x86_64                                                                                                                                  1/4   Installing : mysql-community-libs-5.6.36-2.el7.x86_64                                                                                                                                    2/4   Installing : mysql-community-client-5.6.36-2.el7.x86_64                                                                                                                                  3/4   Installing : mysql-community-server-5.6.36-2.el7.x86_64                                                                                                                                  4/4   Verifying  : mysql-community-server-5.6.36-2.el7.x86_64                                                                                                                                  1/4   Verifying  : mysql-community-common-5.6.36-2.el7.x86_64                                                                                                                                  2/4   Verifying  : mysql-community-libs-5.6.36-2.el7.x86_64                                                                                                                                    3/4   Verifying  : mysql-community-client-5.6.36-2.el7.x86_64                                                                                                                                  4/4 Installed:  mysql-community-server.x86_64 0:5.6.36-2.el7                                                                                                                                                 Dependency Installed:  mysql-community-client.x86_64 0:5.6.36-2.el7                    mysql-community-common.x86_64 0:5.6.36-2.el7                    mysql-community-libs.x86_64 0:5.6.36-2.el7                   Complete!

3.配置

[root@localhost /]# systemctl enable mysqld[root@localhost /]# systemctl start mysqld[root@localhost /]# mysql_secure_installation

4.登录MySQL

[root@localhost /]# mysql -uroot -p
原创粉丝点击