进阶01-mysql安装-Linux

1. 安装VMware
2. 下载centos7镜像
   1. https://www.centos.org/download/
3. 打开VMware导入镜像
4. 设置用户名和密码
5. ip addr查看本机ip地址, ens33下面的地址就是ip地址
6. 开放linux3306端口
   1. sudo firewall-cmd --add-port=3306/tcp --permanent
   2. sudo firewall-cmd --reload
7. 确认端口是否开放
   1. sudo firewall-cmd --list-ports | grep 3306
8. 记住ip地址，使用final-shell连接
9. 上传mysql安装包到root目录下
   1. mysql安装包：
   2. 链接：https://pan.baidu.com/s/1PbJZfDWilh_ms1PFiOJkOw?pwd=6666
   3. 提取码：6666
10. 创建目录并解压
11. mkdir mysql
12. tar -xvf mysql-8.0.26-1.el7.x86_64.rpm-bundle.tar -C mysql
13. 安装mysql

cd mysql

rpm -ivh mysql-community-common-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-client-plugins-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-libs-8.0.26-1.el7.x86_64.rpm 

rpm -ivh mysql-community-libs-compat-8.0.26-1.el7.x86_64.rpm

yum install openssl-devel

rpm -ivh  mysql-community-devel-8.0.26-1.el7.x86_64.rpm

rpm -ivh mysql-community-client-8.0.26-1.el7.x86_64.rpm

rpm -ivh  mysql-community-server-8.0.26-1.el7.x86_64.rpm

12. 启动

systemctl start mysqld
systemctl restart mysqld
systemctl stop mysqld

13. 查询密码
14. grep ‘temporary password’ /var/log/mysqld.log
15. 登录：mysql -u root -p
16. 修改密码
17. 设置策略：
    1. set global validate_password.policy = 0;
    2. set global validate_password.length = 6;
18. ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;
19. 创建用户
20. 默认的root用户只能当前节点localhost访问，是无法远程访问的，我们还需要创建一个root账户，用户远程访问
21. create user ‘root’@‘%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
22. 分配权限：grant all on . to ‘root’@‘%’;
23. 完成，可以通过DataGrip或者Navicat连接了