yum 安装 mysql5.6

1、安装依赖库

 
 
yum -y update

2、添加MySQL YUM仓库

 
 
wget http://dev.mysql.com/get/mysql-community-release-el5-5.noarch.rpm
rpm -Uvh mysql-community-release-el5-5.noarch.rpm

3、添加/etc/yum.repos.d/mysql-community.repo

 
 
vim /etc/yum.repos.d/mysql-community.repo

添加内容

 
 
# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=//repo.mysql.com/yum/mysql-5.6-community/el/5/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql 

4、用yum安装MySQL

 
 
yum install mysql-community-server 

5、清除旧数据库文件

 
 
mv /var/lib/mysql /var/lib/mysql-bak

6、启动MySQL

 
 
service mysqld start

7、YUM安装MySQL目录说明

 
 
/var/log/mysqld.log #MySQL日志目录
/var/lib/mysql #MySQL数据文件目录
/usr/share/mysql/ #MySQL配置文件目录
/usr/bin/ #MySQL启动脚本目录

8、设置用户

 
 
CREATE user test_user;
USE mysql;
UPDATE user SET password=PASSWORD("TEST_PASSWORD") WHERE user='test_user';
GRANT ALL ON *.* TO 'test_user'@'%';
FLUSH PRIVILEGES; 

9、设置默认字符编码
①、添加my.cnf（若存在此文件，请忽略此步骤）

 
 
 cp /usr/share/mysql/my-default.cnf /etc/my.cnf

②、查询数据库编码

 
 
show variables like 'character_set_%';

③、修改/etc/my.cnf
添加内容：

 
 
 character_set_server=utf8