Springboot 高级实战项目开发（一）

一、学习资源

1、学习视频网站

B站 雷丰阳_尚硅谷 springboot核心篇+springboot整合篇

2、文档

springboot高级

3、docker安装mysql

1、拉取镜像

# mysql最新版
docker pull mysql

# 拉取MySQL5.7
# docker pull centos/mysql-57-centos7

2、查看镜像

➜  ~ docker images
REPOSITORY              TAG                  IMAGE ID            CREATED             SIZE
mysql                   latest               0d64f46acfd1        6 hours ago         544MB
rabbitmq                3-management         43f79d83563f        5 weeks ago         187MB
rabbitmq                latest               bdd22a0ccf73        5 weeks ago         156MB
tensorflow/tensorflow   latest-py3-jupyter   c652a4fc8a4f        10 months ago       1.22GB

3、启动

# 将mysql端口映射到宿主机 33306端口，宿主机可以通过 33306访问该服务
docker run -p 33306:3306 --name mysql01 -e MYSQL_ROOT_PASSWORD=123456 -d mysql

docker run -p 33307:3306 --name mysql02 -e MYSQL_ROOT_PASSWORD=123456 -d centos/mysql-57-centos7

docker指令：docker run  -p  ip:hostPort:containerPort  redis

进入容器内部

docker exec -it  3d4b /bin/bash

root@3d4bae4a878c:/# mysql -uroot -p123456

navicat连接报错：Authentication plugin 'caching_sha2_password' cannot be loaded的处理方法
更改：

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.02 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Query OK, 0 rows affected (0.00 sec)

mysql>  FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'
    -> ;
Query OK, 0 rows affected (0.01 sec)

为者常成，行者常至