Install MariaDB database using yum in CentOS

Install MariaDB database using yum in CentOS

Because there is no MariaDB repository on CentOS by default, you need to install rep first.

Step 1. Generate a repo File
(1) create a new repo File
# Nano/etc/yum. repos. d/MariaDB. repo
(2) Add content
[Mariadb]
Name = MariaDB
Base url = http://yum.mariadb.org/5.5/centos6-amd64
Gpgkey = https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Gpgcheck = 1
(3) Ctrl + O, Ctrl + X save and exit

Step 2. Update the Repository
# Yum-y update

Step 3. Install MariaDB
Yum-y install MariaDB-client MariaDB-server MariaDB-devel

Step 4. Start MariaDB
Service mysql start
:) OK. The installation is successful. You can close your work for lunch...
Supplement: I want to eat... Remove the case sensitivity. (the default table name in linux is case sensitive, which is inconvenient to use )...

Step 5. Remove the case sensitivity of the table name
Cp/etc/my. cnf. d/server. cnf/etc/my. cnf
Add:
Lower_case_table_names = 1
In this way, the system automatically converts the table name to lowercase. Remember to perform this operation before using the database. Otherwise, the change will be depressing, especially when the database name also has uppercase letters.

Install LAMP (Apache with MariaDB and PHP) in CentOS/RHEL/Scientific Linux 6)

Implementation of MariaDB Proxy read/write splitting

Install MariaDB and MySQL

MariaDB details: click here
MariaDB's: click here