Offline installation of mariadb 10.0.20 using RPM packages, based on CentOS 6.6-x86-64

Install MariaDB 10.0.20 using the RPM package [offline], based on the CentOS 6.6-x86-64 Minimal

Hunan Zhu Health 2015-07-01 in Shenzhen Futian

qq:872007255 mariadb AC Group: 198111730

Document Description:

1. There are many web-based Mariadb/mysql Database installation technology blog documents, mainly source code compiled installation and Yum source installation, some are very well written, but very few of the offline RPM package installed.

2. Source code compilation and installation for beginners, the threshold is too high, it is easy to combat mariadb beginners learning to explore the enthusiasm; Yum installation, foreign yum source access speed is very slow, too time-consuming; Both of these methods have shortcomings.

3. This article uses the downloaded offline RPM package, can be applied to a variety of hardware and software environments for rapid installation deployment, even without internet access, can also be installed with local Yum Source rapid installation of the MARIADB database.

4. The compilation and installation is too complicated, the installation effect and RPM installation, Yum installation effect is exactly the same, ultimately through the subsequent configuration to optimize performance, so that it can achieve optimal running state.

5. This document is specially developed for beginners who are interested in learning more about the MARIADB database, and the interested Daniel can also refer to it, if there are deficiencies, I hope to enlighten you.

6. This article is 100% original content, unauthorized reproduction or for other commercial purposes, author: Zhu Xian Wen, pseudonym: Hunan Zhu Health, e-mail: [Email protected]

1. Go to mariadb website to download mariadb required RPM package,: http://yum.mariadb.org/10.0.20/centos6-amd64/rpms/

2. Use the download software to download the required RPM package, a total of 4, and upload to the CentOS host specified directory.

mariadb-10.0.20-centos6-x86_64-server.rpm

mariadb-10.0.20-centos6-x86_64-client.rpm

mariadb-10.0.20-centos6-x86_64-common.rpm

mariadb-10.0.20-centos6-x86_64-compat.rpm

3. The dependencies required to install the MARIADB

Yum install Libaio perl perl-dbi perl-module-pluggable perl-pod-escapes perl-pod-simple perl-libs perl-version

4. Remove all existing MySQL packages first

Yum Remove mysql*

5. Go to RPM Package directory location, install MARIADB

Rpm-i mariadb*

6. After the installation is complete, start the MARIADB service

Service MySQL Start

Mysql

7. Initialize MARIADB basic settings

7.1 is the root user [root in this case is the MARIADB database administrator, not the CentOS system administrator root] setting the native access password

Set password for ' root ' @ ' localhost ' = password (' Root_password ');

7.2 Enter the system database MySQL, delete the empty password mariadb user account

Use MySQL;

Select User, host, password from user;

Delete from user where user= "" or password= "";

Commit

service MySQL restart;

7.3 Re-login with new password mariadb

Mysql-u root-p

Root_password

7.4 Authorization MARIADB database root user remote Access [This step is set according to actual needs]

Grant all privileges on * * to ' root ' @ '% ' identified by ' Root_remote_password ';

7.5 Additional instructions: Many articles on the internet need to modify the iptables of the CentOS system, open the MARIADB database default service port 3306, in fact, only when the database service is open to external programs to access the database service port need to open, Production environment if the application and database are on the same host, it is recommended that you do not open the database service port for security reasons.

Offline installation of mariadb 10.0.20 using RPM packages, based on CentOS 6.6-x86-64