centos7安装mysql8.0简书_Centos7安装mysql8.0

环境说明

centos7

注意：这是我安装很多次失败中总结，希望你可以按照我的步骤，一步一步来，应该是不会有问题的。

如果你已经安装了mysql，需要先卸载，卸载请参考：

Centos7 完全卸载mysql

检查 MariaDB 是否安装

yum list installed | grep mariadb

image.png

卸载全部 MariaDB 相关

yum -y remove mariadb*

image.png

数据准备

下载mysql安装包

[root@localhost ~]# cd /usr/local/src/

[root@localhost src]# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

下载完后可以目录中看到：

image.png

安装mysql源

rpm -ivh mysql80-community-release-el7-3.noarch.rpm

image.png

检查 MySQL 的 YUM 源是否安装成功

yum repolist enabled | grep "mysql.*-community.*"

image.png

查看 MySQL 版本

yum repolist all | grep mysql

image.png

安装 MySQL

yum install mysql-community-server

image.png

启动mysql服务

systemctl start mysqld

附加命令

查看MySQL状态 systemctl status mysqld

关闭MySQL服务 systemctl stop mysqld

重启MySQL服务 systemctl restart mysqld

image.png

查看自动生成的临时密码

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

image.png

这个密码先自己保存下

登录mysql

使用刚才生成的临时密码

mysql -uroot -p

image.png

这时候对数据的操作会报错，必须先改密码

image.png

mysql8.0修改密码和以往不同，我看过别的教程，修改成功后，无法使用该密码进行登录，正确方式如下(引号后面是密码)

密码需要包含大小写字母、数字、符号长度也不能过短，暂时先弄一个很长的，一会再改。

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "#20as3SElk3@wwerwer232342432342343223243sdfasfafasdsds0ew98";

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "#20as3SElk3@wwerwer232342432342343223243sdfasfafasdsds0ew98";

刷新

FLUSH privileges;

此时我们退出，重新登录看看效果

(输入密码我们用复制的，在xshell中操作)

mysql> quit;

Bye

[root@localhost src]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 9

Server version: 8.0.17 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

可以登录！

设置安全策略

因为要把刚才的密码改的简单一点，这里需要先修改安全策略，mysql8.0修改安全策略的命令和5.7不同，具体如下

先选择数据库：

use mysql;

5.7语法：

set global validate_password_policy=0;set global validate_password_length=1;

8.0语法：

set global validate_password.policy=0;

set global validate_password.length=1;

最后都要刷新：

FLUSH privileges;

修改密码

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY "123456";

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

退出重新登录

输入刚才修改的密码

mysql> quit;

Bye

[root@localhost src]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 11

Server version: 8.0.17 MySQL Community Server - GPL

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

设置远程访问

mysql> CREATE USER 'root'@'%' IDENTIFIED BY '123456';

Query OK, 0 rows affected (2.30 sec)

mysql> GRANT ALL ON *.* TO 'root'@'%';

Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.03 sec)

mysql>

开启防火墙

[root@localhost src]# firewall-cmd --zone=public --add-port=3306/tcp --permanent

success

[root@localhost src]# firewall-cmd --reload

success

image.png