http://www.cnblogs.com/mchina/archive/2013/01/04/2842275.html
yum安装最新版mysql
rpm -ivh mysql-community-release-el6-5.noarch.rpm
yum localinstall -y mysql-community-release-el6-5.noarch.rpm //在安装包文件安装
yum repolist enabled |grep mysql
yum -y install mysql mysql-server mysql-libs mysql-devel
service mysqld restart
chkconfig mysqld on
SHOW VARIABLES where variable_name LIKE 'character_set_%'or variable_name LIKE 'collation_%';
//查看当前MYSQL服务器字符集设置和校验设置
show variables like '%max_connections%'; //查看连接数
增加mysql连接数
max_connections=8192
max_connect_errors=4096
max_allowed_packet = 4M
添加了utf8mb4字符集的选项集
vim /etc/my.cnf
[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
replicate-wild-ignore-table = mysql.%
//mysql主从不同步权限
删除包
rpm -e MySQL-server-5.6.17-1.el6.i686
rm -rf /usr/lib/mysql
rm -rf /usr/share/mysql
rm -rf /usr/my.cnf
yum remove mysql mysql-server mysql-libs compat-mysql51
rm -rf /var/lib/mysql
rm /etc/my.cnf