HostOnNet Blog

Installing MySQL on CentOS 7

CentOS 7 stopped shipping MySQL as it is owned by Database company Oracle, many doubt Oracle will use MySQL to sell their Oracle Database. Now CentOS ship with MariaDB. It is created by creator of MySQL. He sold MySQL to Sun Microsystems (creator of Java), later Oracle acquired Sun (and killed it ?).

mariadb

Luckily for us, MySQL creator have another daughter, Maria, so he named his version of MySQL MariaDB. “My” was name of his first daughter, like father, she won’t be happy with this change.

[root@cloud1 ~]# yum search mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: centos.mirror.nac.net
 * extras: mirrors.advancedhosters.com
 * updates: mirror.kentdigital.net
============================================================================================ N/S matched: mysql =============================================================================================
MySQL-python.x86_64 : An interface to MySQL
akonadi-mysql.x86_64 : Akonadi MySQL backend support
apr-util-mysql.x86_64 : APR utility library MySQL DBD driver
dovecot-mysql.x86_64 : MySQL back end for dovecot
freeradius-mysql.x86_64 : MySQL support for freeradius
libdbi-dbd-mysql.x86_64 : MySQL plugin for libdbi
mysql-connector-java.noarch : Official JDBC driver for MySQL
mysql-connector-odbc.x86_64 : ODBC driver for MySQL
perl-DBD-MySQL.x86_64 : A MySQL interface for Perl
php-mysql.x86_64 : A module for PHP applications that use MySQL databases
php-mysqlnd.x86_64 : A module for PHP applications that use MySQL databases
qt-mysql.i686 : MySQL driver for Qt's SQL classes
qt-mysql.x86_64 : MySQL driver for Qt's SQL classes
qt3-MySQL.i686 : MySQL drivers for Qt 3's SQL classes
qt3-MySQL.x86_64 : MySQL drivers for Qt 3's SQL classes
redland-mysql.x86_64 : MySQL storage support for Redland
rsyslog-mysql.x86_64 : MySQL support for rsyslog
mariadb.x86_64 : A community developed branch of MySQL
mariadb-devel.i686 : Files for development of MariaDB/MySQL applications
mariadb-devel.x86_64 : Files for development of MariaDB/MySQL applications
mariadb-libs.i686 : The shared libraries required for MariaDB/MySQL clients
mariadb-libs.x86_64 : The shared libraries required for MariaDB/MySQL clients

  Name and summary matches only, use "search all" for everything.
[root@cloud1 ~]# 

MariaDB is drop in replacement (binary compatible) for MySQL, so nothing to worry about it. Lets install mariadb.

yum install -y mariadb mariadb-server mariadb-devel

With CentOS 7, we don’t have “service mysql start”, instead we need to use systemctl

To start MariaDB, run

systemctl start mariadb

To stop, run

systemctl stop mariadb

Posted in Linux