mysql 5.6搭建总结

Yum 安装：
1.yum localinstall mysql-community-release-el6-5.noarch.rpm
2.yum install mysql-community-server

安装包安装：
1. tar -zxvf mysql-5.6.29-linux-glibc2.5-x86_64.tar.gz
2. cp mysql-5.6.29-linux-glibc2.5-x86_64 /usr/local/mysql –R
3. cd /usr/local/mysql
4. groupadd mysql
5. useradd -r -g mysql mysql
6. chown -R mysql .
7. chgrp -R mysql .
8. scripts/mysql_install_db --user=mysql
9. ./bin/mysqladmin -u root password 'root'
10. chown -R root .
11. chown -R mysql data
12. bin/mysqld_safe --user=mysql &
13. # Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server

mysql.cnf配置:
server-id=1

log_bin=mysqlbin
expire_logs_days=10
max_binlog_size=100M

binlog_format=ROW  

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock


# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

# Recommended in standard MySQL setup
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server=utf8
lower_case_table_names=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


授权远程访问： Cannot connect to specified instance issue：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;