centos6.7 安装mysql5.6的步骤

1. 卸载原来的mysql5.1的步骤

Last login: Thu May 19 14:55:27 2016 from 171.221.202.147
[root@47d92e70b7ed ~]# rpm -qa | grep mysql
mysql-devel-5.1.73-5.el6_6.x86_64
mysql-libs-5.1.73-5.el6_6.x86_64
mysql-server-5.1.73-5.el6_6.x86_64
mysql-5.1.73-5.el6_6.x86_64
[root@47d92e70b7ed ~]# rpm -e --nodeps mysql-libs-5.1.73-5.el6_6.x86_64
warning: /etc/my.cnf saved as /etc/my.cnf.rpmsave
[root@47d92e70b7ed ~]# rpm -e --nodeps mysql-devel-5.1.73-5.el6_6.x86_64
[root@47d92e70b7ed ~]# rpm -e --nodeps mysql-server-5.1.73-5.el6_6.x86_64
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
[root@47d92e70b7ed ~]# rpm -e --nodeps mysql-5.1.73-5.el6_6.x86_64
[root@47d92e70b7ed ~]# rpm -qa | grep mysql
[root@47d92e70b7ed ~]#

2. 要将 /var/lib/mysql文件夹下的所有文件都删除干净

3. 下载http://mirrors.sohu.com/mysql/MySQL-5.6/MySQL-5.6.30-1.el6.x86_64.rpm-bundle.tar
解压 tar -xvf MySQL-5.6.30-1.el6.x86_64.rpm-bundle.tar
然后会出现
MySQL-devel-5.6.30-1.el6.x86_64.rpm
MySQL-shared-5.6.30-1.el6.x86_64.rpm
MySQL-test-5.6.30-1.el6.x86_64.rpm
MySQL-embedded-5.6.30-1.el6.x86_64.rpm
MySQL-client-5.6.30-1.el6.x86_64.rpm
MySQL-shared-compat-5.6.30-1.el6.x86_64.rpm
MySQL-server-5.6.30-1.el6.x86_64.rpm

依次安装
yum install libaio
yum install numactl

rpm -ivh MySQL-server-5.6.30-1.el6.x86_64.rpm
rpm -ivh MySQL-devel-5.6.30-1.el6.x86_64.rpm
rpm -ivh MySQL-client-5.6.30-1.el6.x86_64.rpm

3. 启动mysql
service mysql start
/etc/rc.d/init.d/mysql status 查看启动状态

4. 安装完成之后为MySQL设置root密码。
命令如下：
# mysql -u root -p
我这里是123456

5。修改配置
1、拷贝 cp /usr/share/mysql/my-default.cnf /etc/my.cnf
2、修改my.cnf 文件，由于我用django，需要长链接
###########################################
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
wait_timeout=864000000000000
interactive_timeout=864000000000000
port=3309

#下面这三句是内存调优，云主机就1G内存，你就吃50%，加下面三句，内存瞬间降到8%

performance_schema_max_table_instances=1000
table_definition_cache=200
table_open_cache=200

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

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
###########################################

service mysql restart即可