mysql5.7 - yum 安装方法

Mysql yum 安装方法

1.官网下载mysql-community-release的rpm包（社区版）

mysql5.6的下载方式：wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
mysql5.7的下载方式：wget https://repo.mysql.com//mysql57-community-release-el6-11.noarch.rpm

这里以5.7版本为例截图

2.用来安装配置mysql yum源的安装包
yum localinstall -y mysql57-community-release-el6-9.noarch.rpm

3.yum 安装mysql server

yum install mysql-community-server

4.service mysqld start

5.skip-grant-tables 配置到/etc/my.cnf service mysql restart

6.修改密码
update mysql.user set authentication_string=password(“password”) where user=”root”;

7.有的安装后输入命令会报错
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
需要再重置下密码
mysql> SET PASSWORD = PASSWORD(“password”);
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)