Centos 6.5 安装 mysql5.7

1. 检查每户是否已安装过mysql 或者其它依赖,通常CentOs6.5 默认安装了 5.1.71的mysql包.

  - yum list installed | grep mysql  //查询安装包
  - mysql-libs.i686         5.1.71-1.el6      @anaconda-CentOS-201311271240.i386/6.5

  - yum -y remove mysql-libs.i686 5.1.71-1.el6   //删除包名

2. 从mysql 官网下载 mysql57-community-release-el6-9.noarch.rpm

wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

3. 下载完成 rpm 包后, 安装

yum install mysql57-community-release-el6-9.noarch.rpm

4. 安装成后, 我们可以查看是否有 mysql57 安装源.

ls /etc/yum.repos.d
mysql-community-source.repo
mysql-community.repo

5. 使用yum安装mysql

yum install mysql-community-server

6. 启动mysql服务

service mysqld start
 ![image.png](https://img.haomeiwen.com/i2005591/94b5698b2843ec07.png?imageMogr2/auto-orient/strip%7CimageView2/2/w/1240)

初次运行后,会初始化密码.
查看root 初始化密码

grep "password" | /var/log/mysqld.log
2017-03-26T10:26:38.295192Z 1 [Note] A temporary password is generated for root@localhost: S&2=d(wtlU2,
S&2=d(wtlU2,   -> 为密码

现在必须立刻修改密码

mysql -u root -p
输入初始化密码
修改密码

mysql> set password for 'root'@'localhost' = password('newpassword');

现在mysql就算已经安装成功！

7. 查看并设置开机自启动.

chkconfig --list | grep mysqld
chkconfig mysqld on

8. 修改字符集为UTF-8

vim /etc/my.cnf

在[mysqld]部份添加:

character-set-server=utf8

在文件末尾新增[client]段,并在[client]段添加:

default-character-set=utf8

修改好之后重启mysqld服务

service mysqld restart

查看修改结果

mysql> show variables like "%character%";
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

好了, 安装完成. 注:密码必须是大小写字母加数字 和特殊字符.