Installation method
Http://dev.mysql.com/doc/refman/5.6/en/binary-installation.html
Shell>groupadd mysql
Shell>useradd -r -g mysql -s /bin/false mysql
Shell>cd /usr/local
Shell>tar zxvf /path/to/mysql-VERSION-OS
.tar.gz
Shell>ln -s full-path-to-mysql-VERSION-OS
mysql
Shell>cd mysql
Shell>chown -R mysql .
Shell>chgrp -R mysql .
Shell>scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql
Shell>chown -R root .
Shell>chown -R mysql data
Shell>bin/mysqld_safe --user=mysql &
# Next command is optional
Shell>cp support-files/mysql.server /etc/init.d/mysql.server
MY.CNF file
[Client]
Port = 3306
Default-character-set = UTF8
Socket =/tmp/mysql.sock
[Mysqld]
Character-set-server = UTF8
Collation-server = Utf8_general_ci
Port = 3306
Socket =/tmp/mysql.sock
Basedir =/usr/local/mysql
DataDir =/usr/local/mysql/data
Skip-external-locking key_buffer_size = 16M
Max_allowed_packet = 1M
Table_open_cache = 64
Sort_buffer_size = 512K
Net_buffer_length = 8K
Read_buffer_size = 256K
Read_rnd_buffer_size = 512K
Myisam_sort_buffer_size = 8M
Log-bin=mysql-bin binlog_format=mixed Server-id = 1
[Mysqldump] Quick Max_allowed_packet = 16M
[MySQL] No-auto-rehash
[Myisamchk] key_buffer_size = 20M Sort_buffer_size = 20M Read_buffer = 2M Write_buffer = 2M
[Mysqlhotcopy] Interactive-timeout
Error if no red option is added
FATAL error:could not find./bin/my_print_defaults
MySQL 5.6.342 binary