Home » Msyql » How to install and Configure MariaDB on Centos 6

How to install and Configure MariaDB on Centos 6

MariaDB is a community-developed branching of the MySQL relational database management system, the impulse being the community fixing of its free status under the GNU GPL. Being a branch of a leading open source application system, it is famous for being led by its original developers and induction by concerns over direction by an getting commercial company Oracle. In this article you will learn that how to install MariaDB on Centos server

Setup the maria repository

Centos 6 32-bit

[root@linuxpcfix~]vi /etc/yum.repos.d/MariaDB.repo

and append following line:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Centos 6 64-bit

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Now start installation process
if you have mysql installed then remove it

[root@rohit ~]# yum remove mysql-server
Loaded plugins: fastestmirror
Setting up Remove Process
Resolving Dependencies
–> Running transaction check
—> Package mysql-server.x86_64 0:5.1.73-3.el6_5 will be erased
–> Finished Dependency Resolution
Repository mariadb is listed more than once in the configurationDependencies Resolved====================================================================================
Package                                    Arch                                Version                         Repository                                  Size
===========================================================================================
Removing:
mysql-server                         x86_64                           5.1.73-3.el6_5              @updates                                 25 M
Transaction Summary
===========================================================================================
Remove 1 Package(s)Installed size: 25 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Erasing : mysql-server-5.1.73-3.el6_5.x86_64 1/1
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Verifying : mysql-server-5.1.73-3.el6_5.x86_64 1/1Removed:
mysql-server.x86_64 0:5.1.73-3.el6_5Complete!

Now execute the following command to start MariaDB installation

[root@linuxpcfix~]#yum install MariaDB-server MariaDB-client
Loaded plugins: fastestmirror
* ius: ord.mirror.rackspace.com
Setting up Install Process
Package MariaDB-client-5.5.40-1.el6.x86_64 already installed and latest version
Resolving Dependencies
–> Running transaction check
—> Package MariaDB-server.x86_64 0:5.5.40-1.el6 will be installed
–> Finished Dependency ResolutionDependencies Resolved=================================================================================
Package                                         Arch                                 Version                                  Repository                          Size
========================================================================================
Installing:
MariaDB-server                         x86_64                             5.5.40-1.el6                          mariadb                              43 M
Transaction Summary
=========================================================================================
Total download size: 43 M
Installed size: 174 M
Is this ok [y/N]: y
Downloading Packages:
MariaDB-5.5.40-centos6-x86_64-server.rpm | 43 MB 00:39
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : MariaDB-server-5.5.40-1.el6.x86_64 1/1
chown: cannot access `/var/lib/mysql’: No such file or directoryPLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:’/usr/bin/mysqladmin’ -u root password ‘new-password’
‘/usr/bin/mysqladmin’ -u root -h rohit.hrn9.com password ‘new-password’Alternatively you can run:
‘/usr/bin/mysql_secure_installation’which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from
SkySQL Ab. You can contact us about this at sales@skysql.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/

Verifying : MariaDB-server-5.5.40-1.el6.x86_64 1/1

Installed:
MariaDB-server.x86_64 0:5.5.40-1.el6

Complete!

Finally start the MariaDB server

[root@rohit ~]# service mysql start
Starting MySQL…. SUCCESS!
[root@linuxpcfix ~]#

Enjoy!

About

I am founder and webmaster of www.linuxpcfix.com and working as a Sr. Linux Administrator (Expertise on Linux/Unix & Cloud Server) and have been in the industry from last 7 years.

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*

Time limit is exhausted. Please reload the CAPTCHA.

Categorized Tag Cloud