MariaDB数据库管理系统是MySQL的一个分支,主要由开源社区在维护,采用GPL授权许可;
MariaDB的目的是完全兼容MySQL,包括API和命令行,使之能轻松成为MySQL的代替品。
Centos7默认安装mariadb,所以yum install -y mysql*时安装的就不是MySQL了。
那么如何实现安装MySQL而非Mariadb呢?
- 卸载mariadb
列出所有被安装的rpm package
[root@localhost install]# rpm -qa | grep mariadb
mariadb-libs-5.5.52-1.el7.x86_64
mariadb-5.5.52-1.el7.x86_64
mariadb-bench-5.5.52-1.el7.x86_64
mariadb-devel-5.5.52-1.el7.x86_64
mariadb-embedded-devel-5.5.52-1.el7.x86_64
mariadb-embedded-5.5.52-1.el7.x86_64
mariadb-server-5.5.52-1.el7.x86_64
mariadb-test-5.5.52-1.el7.x86_64
卸载
[root@localhost install]# yum -y remove mariadb*
Loaded plugins: fastestmirror, langpacks
Resolving 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 Resolution
Dependencies 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 M
Removing 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 M
Transaction Summary
===================================================================================================================
Remove 8 Packages (+2 Dependent packages)
Installed size: 292 M
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running 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.rpm
Retrieving http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
Preparing... ################################# [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 36
mysql-tools-community/x86_64 MySQL Tools Community 47
mysql56-community/x86_64 MySQL 5.6 Community Server 327
直接用yum方式安装了MySQL5.6版本了:
[root@localhost /]# yum -y install mysql-community-server
Loaded plugins: fastestmirror, langpacks
Loading 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 M
Installing 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 M
Transaction Summary
===============================================================================================================================================================================================
Install 1 Package (+3 Dependent packages)
Total download size: 81 M
Installed size: 351 M
Downloading 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