mysql 安装

Mysql

下载地址：https://dev.mysql.com/downloads/mysql/

参照：https://blog.csdn.net/lizy928/article/details/82531749

1、下载安装包：

```

wget http://repo.mysql.com/mysql57-community-release-el7-8.noarch.rpm

```

```

wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm

```

2、若是没有wget，可以：

```

sudo yum install wget

```

3、安装下载的mysql

```

sudo rpm -ivh mysql57-community-release-el7-8.noarch.rpm

```

```

sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm

```

4、安装mysql服务端

```

sudo yum install mysql-server

```

5、获取密码：

```

sudo grep 'temporary password' /var/log/mysqld.log

```

如下：

```

2019-10-16T05:42:22.071404Z 1 [Note] A temporary password is generated for root@localhost: h5s/X_7FLkzj

```

6、倘若获取不到，删除原来安装过的mysql残留的数据（这一步非常重要，问题就出在这）

```

rm -rf /var/lib/mysql

```

7、接着，重启mysql 服务器

```

systemctl restart mysqld

```

8、继续执行第五步

```

sudo grep 'temporary password' /var/log/mysqld.log

```

9、配置mysql

```

sudo mysql_secure_installation

```

修改新密码，然后不断enter

 

10、进入mysql

```

mysql -uroot -p

```

密码：h5s/X_7FLkzj

 

11、开启远程服务，执行两步命令

 

【同时：Linux服务器那边需要开放3306端口，在安全组里面设置】

 

```

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'h5s/X_7FLkzj' WITH GRANT OPTION;

```

```

flush privileges;

```

12、倘若11执行失败，提示修改密码

 

```

update user set authentication_string=passworD("test") where user='root';

```

中文格式配置：

修改mysql配置文件/etc/my.cnf。

vim /etc/my.cnf

```

[client]

default-character-set=utf8

[mysqld]

default-storage-engine=INNODB

character-set-server=utf8

collation-server=utf8_general_ci

```

重启mysql：

```

systemctl restart mysqld

```