百度云盘:
https: / / pan. baidu. com/ s/ 1 RcKct7_CffWK5bRgzUNNLQ
不需要提取码
安装说明:
https: / / www. cnblogs. com/ yanglang/ p/ 10782941. html
操作记录
mkdir mysql
40 ll
41 cd my
42 cd mysql/
43 ll
45 tar - xvf mysql- 8.0 .19 - 1. el7. x86_64. rpm- bundle. tar
46 ll
47 rpm - ivh mysql- community- common- 8.0 .19 - 1. el7. x86_64. rpm -- nodeps -- force
48 rpm - ivh mysql- community- libs- 8.0 .19 - 1. el7. x86_64. rpm -- nodeps -- force
49 rpm - ivh mysql- community- client- 8.0 .19 - 1. el7. x86_64. rpm -- nodeps -- force
50 rpm - ivh mysql- community- server- 8.0 .19 - 1. el7. x86_64. rpm -- nodeps -- force
51 rpm - qa | grep mysql
52 mysqld -- initialize;
53 chown mysql: mysql / var/ lib/ mysql - R;
54 systemctl start mysqld. service;
55 systemctl enable mysqld;
56 cat / var/ log/ mysqld. log | grep password
57 mysql - uroot - p
58 systemctl stop firewalld. service;
59 systemctl disable firewalld. service;
60 systemctl mask firewalld. service;
61 ifconfig
通过 cat / var/ log/ mysqld. log | grep password 命令查看数据库的密码
通过 mysql - uroot - p 敲回车键进入数据库登陆界面
通过 ALTER USER 'root' @'localhost' IDENTIFIED WITH mysql_native_password BY 'root' ; 命令来修改密码
通过 exit; 命令退出 MySQL,然后通过新密码再次登陆
. 通过以下命令,进行远程访问的授权
create user 'root' @'%' identified with mysql_native_password by 'root' ;
grant all privileges on * . * to 'root' @'%' with grant option;
flush privileges;
通过 ALTER USER 'root' @'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; 命令修改加密规则,MySql8. 0 版本 和 5.0 的加密规则不一样,而现在的可视化工具只支持旧的加密方式。
通过 flush privileges; 命令刷新修该后的权限
通过以下命令,关闭 firewall ( 防火墙)
systemctl stop firewalld. service;
systemctl disable firewalld. service;
systemctl mask firewalld. service;