Yum Source Installation MariaDB-10.0 Database

1. Configure the Yun source to find the appropriate version of your system in http://yum.mariadb.org/
Vim/etc/yum.repos.d/mariadb.repo

[MARIADB]
Name = MariaDB
BaseURL = Http://yum.mariadb.org/10.0/centos6-amd64
Gpgkey=https://yum.mariadb.org/rpm-gpg-key-mariadb
Gpgcheck=1

2.yum Installation
Yum-y Install mariadb-client Mariadb-server

3. Start MySQL
Service MySQL Start

4. Change the root password
mysqladmin-u root password ' 111111 '

5. Log in to the database
. mysql-u Root-p

6. Permission to grant remote access
GRANT all privileges on . To ' root ' @ '% ' identified by ' 111111 ' with GRANT OPTION;

7. Modify the configuration file as needed
Vim/etc/my.cnf

[Mysqld]
Default-storage-engine=innodb
Character-set-server=utf8
Collation-server=utf8_general_ci
Slow-query-log-file=/var/lib/mysql/slowquery.log
Long_query_time=1
Log-queries-not-using-indexes
Log-bin=mysqlbin-log

Yum Source Installation MariaDB-10.0 Database