MySQL 5.6.342 binary

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