Install binary mariadb on CentOS-6

Objective:

three different forms of packages are available on the official website of MARIADB: Source Package, Package Manager, and binary, as shown in. Binary plate is compiled by the official green version, compared to the source package version installation is more simple than the Package Manager version of a little more freedom, is considered a compromise between the two. Also note that it relies on glibcand needs to be aware of the glibc version.

Installation:

Step One:

First confirm the glibc version, you can see that CentOS-6 is installed on the glibc-2.12 version, so you need to download

# rpm-q Glibcglibc-2.12-1.166.el6.x86_64

Step Two:

Close Iptables and SELinux

Step Three:

# Create System user MySQL

# useradd-r MySQL

# Unzip to directory/usr/local/

# TAR-XF Mariadb-5.5.43-linux-x86_64.tar.gz-c/usr/local/

# Create a soft link mysql

# cd/usr/local/# LN-SV mariadb-5.5.43-linux-x86_64/mysql "MySQL", "mariadb-5.5.43-linux-x86_64/"

# Modify Directory owner and owner group

# Chown-r Root:mysql.

# Create a database directory. Use the data directory in the current directory as the database directory by default if you do not create and specify it separately

# mkdir-pv/data/mysqlmkdir:created directory '/data ' mkdir:created directory '/data/mysql '

# Modify the database directory's owner and host group as MySQL

# Chown-r mysql:mysql/data/mysql/

# Install the database

# scripts/mysql_install_db--user=mysql--datadir=/data/mysql

Configuration

# import the bin directory path to the PATH environment variable

# Vim/etc/profile.d/mysql.shexport Path=/usr/local/mysql/bin: $PATH

# effective immediately

# EXEC Bash

# Create a header file symbolic link

# cd/usr/local/include/# Ln-s. /mysql/include/mysql/mysql

# import man path to System man manual

# Vim/etc/man.configmanpath/usr/local/mysql/man

# Copy Service script to/ETC/RC.D/INIT.D directory

# cd/usr/local/mysql# CP Support-files/mysql.server/etc/rc.d/init.d/mysqld

# Copy template configuration file to/etc/directory

# CP SUPPORT-FILES/MY-LARGE.CNF/ETC/MY.CNF

# Modify configuration file

# VIM/ETC/MY.CNF

Character:

mysqld for server, MySQLfor the local CLIcommand-line tools, clientthe connection tools for the client include remote connection tools, and so on. All need to set the character set uniformly to Utf-8, special scenes are modified to other character sets according to the actual situation.

[Client]default-charater-set=utf8[mysql]default-charater-set=utf8[mysqld]character-set-server=utf8

Character sorting:

[Mysqld]collation-server=utf8_general_ci

Database directory

[Mysqld]datadir=/data/mysql

Storage Engine

[mysqld]# uses the InnoDB storage engine by default default-storage-engine=innodb# each table uses a separate table space innodb-file-per-table=true

Turn off domain name inverse solution

Skip-name-resolve=true

[client]port            = 3306socket           = /TMP/MYSQL.SOCKDEFAULT-CHARACTER-SET=UTF8[MYSQLD] datadir=/data/mysqlport            =  3306socket          = /tmp/ Mysql.sockskip-external-lockingkey_buffer_size = 256mmax_allowed_packet = 1mtable_open_ cache = 256sort_buffer_size = 1mread_buffer_size = 1mread_rnd_buffer_size =  4mmyisam_sort_buffer_size = 64mthread_cache_size = 8query_cache_size= 16mthread _concurrency = 8character-set-server=utf8collation-server=utf8_general_cidefault-storage-engine= innodbinnodb-file-per-table=trueskip-name-resolve=truelog-bin=mysql-binskip-name-resolve=truelog-bin= Mysql-binbinlog_format=mixedserver-id    &nbsP;  = 1[mysqldump]quickmax_allowed_packet = 16m[mysql] no-auto-rehashdefault-character-set=utf8[myisamchk]key_buffer_size = 128msort_buffer_size =  128mread_buffer = 2mwrite_buffer = 2m[mysqlhotcopy]interactive-timeout

Start the service

/etc/init.d/mysqld start

Boot from Boot

Chkconfig--add mysqldchkconfig mysqld on

Security settings

# mysql_secure_installation /usr/local/mysql/bin/mysql_secure_installation: line 379:  find_mysql_client: command not foundNOTE: RUNNING ALL PARTS OF  this script is recommended for all mariadb       servers in production use!  please read each step carefully! In order to log into mariadb to secure it, we ' ll need  The currentpassword for the root user.  if you ' ve just  Installed mariadb, andyou haven ' t set the root password yet, the  password will be blank,so you should just press enter here. #  initial root password is empty, direct carriage return enter current password for root  (enter for none):  ok, successfully uSed password, moving on ... setting the root password ensures that nobody can log into  The mariadbroot user without the proper authorisation. #设置root密码Set  root  password? [y/n] n ... skipping. by default, a mariadb installation has an anonymous user,  allowing anyoneto log into mariadb without having to have a  user account created forthem.  this is intended only for  Testing, and to make the installationgo a bit smoother.  you  should remove them before moving into aproduction environment.#  Delete anonymous user remove anonymous users? [y/n] n ... skipping. Normally, root should only be allowed to connect from  ' localhost ' .  thisensures that someone cannot  guess at the root password from the network.#  does not allow root remote login disallow  root login remotely? [y/n] n ... skipping. by default, mariadb comes with a database named  ' Test '  that  anyone canaccess.  this is also intended only for testing,  and should be removedbefore moving into a production environment.#   Delete the test database and access its permission settings remove test database and access to it? [y/n]  N ... skipping. Reloading the privilege tables will ensure that all changes made  so farwill take effect immediately.#  Overloaded Permissions List Reload privilege tables  now? [y/n] y ... success! Cleaning up ... All done!  if you ' ve completed all of the above steps,  Your mariadbinstallation should now be secure. thanks for using mariadb!

Install binary mariadb on CentOS-6