Environment Preparation:
CentOS6.5 192.168.30.133
installation package Preparation:
Download the installation package mysql-5.6.15-linux-glibc2.5-x86_64.tar.gz
Specific installation:
[Email protected]_realserver bin]# cd/home/mysql[[email protected]_realserver mysql]# TAR-ZXVF Mysql-5.6.15-linux-glibc2.5-x86_64.tar.gz[[email protected]_realserver mysql]# MV mysql-5.6.15-linux-glibc2.5-x86_ Mysql-5.6.15[[email protected]_realserver ~]# mkdir/mysql3306[[email protected]_realserver ~]# mkdir-p/mysql3306/ Data[[email protected]_realserver ~]# mkdir-p/mysql3306/logs[[email protected]_realserver ~]# mkdir-p/mysql3306/temp [Email protected]_realserver ~]# chown-r mysql:mysql/mysql3306[[email protected]_realserver mysql]# chown-r Mysql:mys QL Mysql-5.6.15/su-mysqlcd/mysql3306/data
Vim my.cnf Edit configuration file
[client] port = 3306socket = /mysql3306/data/mysql.sock [mysqld]user=msqlport= 3306#bind-address=0.0.0.0socket = /mysql3306/data/mysql.sock.3306pid-file = /mysql3306/ Data/mysql.pidbasedir = /home/mysql/mysql-5.6.15datadir = /mysql3306/dataserver-id= 1log-bin=mysql-binlog-bin-index= mysql-bin.index # logginglog_error=/mysql3306/logs/ mysql-error.log slow_query_log_file= /mysql3306/logs/mysql-slow.logslow_query_log= 1character-sets-dir = /home/mysql/mysql-5.6.15/share/charsetsback_log = 2000max_ Connections = 1000connect-timeout = 60wait-timeout = 28800net_buffer_length = 16384max_allowed_packet = 64mthread_stack = 192kthread_cache_size = 20thread_concurrency = 128query_cache_size = 25Mquery_cache_limit = 2mquery_cache_min_res_unit = 2default-time-zone = systemcharacter-set-server = utf8default-storage-engine = innodbtmp_table_size = 51mmax_heap_table_size = 51mmax_binlog_size = 1gmax_relay_log_size = 1g[ Mysql]disable-auto-rehashdefault-character-set = utf8
MySQL account initialization database after saving MY.CNF
cd/home/mysql/mysql-5.6.15./scripts/mysql_install_db--user=mysql--datadir=/mysql3306/data
You can start the database, note the parameters to add the response
MySQL account executed under:
/home/mysql/mysql-5.6.15/bin/mysqld_safe--defaults-file=/mysql3306/my.cnf--user=mysql--basedir=/home/mysql/ mysql-5.6.15--datadir=/mysql3306/data/--ledir=/home/mysql/mysql-5.6.15/bin/
If you do not add the last--ledir parameter, you need to execute the above command from CD to/home/mysql/mysql-5.6.15
mysql-h127.0.0.1 access to the database to modify the appropriate permissions, password modification, and so on.
This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://ericliu2014.blog.51cto.com/8513309/1638151
mysql5.6 source Installation-do not compile