mysql二進制安裝包可以快速搭建好測試mysql，安裝包大小200M多殷费。
# [root@oel1 mysql]# ll -h /data/pkg/mariadb-10.0.10-linux-x86_64.tar.gz
-rw-r--r-- 1 root root 283M 2月 16 07:39 /data/pkg/mariadb-10.0.10-linux-x86_64.tar.gz
安裝過程：
解壓安裝包到指定目錄
# tar xf mariadb-10.0.10-linux-x86_64.tar.gz -C /usr/local
# ln -s /usr/local/mariadb-10.0.10 /usr/local/mysql
# cd /usr/local/mysql
準(zhǔn)備mysql用戶以及目錄屬主乎莉，屬組
# groupadd mysql && useradd mysql
# chown -R mysql.root /usr/local/mysql
# mkdir -p /data/{mysqldata,mysqllogs}
# chown -R mysql.mysql /data/mysqldata
# chown -R mysql.mysql /data/mysqllogs
準(zhǔn)備配置文件
# mv /etc/my.cnf /etc/my.cnf.bk
# cp support-files/mysql.server /etc/init.d/mysqld
# cp support-files/my-large.cnf /etc/my.cnf
# vi /etc/my.cnf
# datadir=/data/mysqldata
# basedir=/usr/local/mysql
# innodb_file_per_table = on
# skip_name_resolve=on
# log-bin=/data/mysqllogs/mysql-bin
# sql-mode=TRADITIONAL
啟動服務(wù)
# ./scripts/mysql_install_db --user=mysql --group=mysql --datadir=/data/mysqldata --basedir=/usr/local/mysql
# chkconfig --add mysqld
# service mysqld start
添加命令path路徑
# vi /etc/profile.d/mysql.sh
# export PATH=/usr/local/mysql/bin:$PATH
# source /etc/profile.d/mysql.sh
登陸數(shù)據(jù)庫易遣，基本設(shè)置
# mysql
# 1、修改root用戶密碼
# 2其爵、刪除空用戶
# 3仰挣、添加訪問權(quán)限
mysql配置文件
datadir=/datadisk/mysqldata/data
socket=/var/lib/mysql/mysql.sock
innodb_file_per_table=on
log-bin=/datadisk/mysqldata/binlog
server-id=101
back_log=210
max_connections=800
character_set_server=GBK
innodb_flush_log_at_trx_commit=2
innodb_read_io_threads=4
innodb_write_io_threads=4
innodb_strict_mode=on
lower_case_table_names=1
max_allowed_packet=1073741824
max_connect_errors=999999999
open_files_limit=102400
slow_launch_time=1
