此處搭建好了docker環境；
1.拉鏡像
docker pull mysql:8.0.20
2.啓動
docker run -p 3306:3306 --name mysql8 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:8.0.203.複製
將容器內mysql的數據配置複製到本機，後面那個路徑就是你想要映射的文件地址
docker cp mysql8:/etc/mysql /home/database/mysql8建議授權一下文件夾 防止權限問題異常, 進入到root目錄
chmod 777 mysql8
4.刪除舊容器
docker stop mysql8 && docker rm mysql8
5.重新按以下命令啓動
docker run -p 13306:3306 --name mysql8 --privileged=true --restart=always -v /home/database/mysql8/mysql:/etc/mysql -v /home/database/mysql8/logs:/logs -v /home/database/mysql8/data:/var/lib/mysql -v /home/database/mysql8/mysql/mysql-files:/var/lib/mysql-files -v /etc/localtime:/etc/localtime -e MYSQL_ROOT_PASSWORD=admin_DEV123 -e MYSQL_DATABASE=baosheng -e MYSQL_USER=lyc -e MYSQL_PASSWORD=lyc_DEV123 -d mysql:8.0.206.修改配置文件，重啓容器
進入容器並登錄，如果發現登錄不了；進入mysql8容器
docker exec -it mysql8 /bin/bash
登錄
mysql -uroot -p ,輸入密碼 如發現登錄不了. 輸入 exit 先退出容器；
進入 /root/mysql8.0.20 文件， 編輯 my.cnf, 在[mysqld]增加一行 skip_grant_tables 此時mysql是無密碼狀態
`
docker restart mysql8`
7.進入數據庫
7.1 查看庫表
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> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| component |
| db |
| default_roles |
| engine_cost |
| func |
| general_log |
| global_grants |
| gtid_executed |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| password_history |
| plugin |
| procs_priv |
| proxies_priv |
| role_edges |
| server_cost |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
33 rows in set (0.00 sec)
mysql>
7.2 查看用户表
mysql> select host,user,plugin from user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | lyc | caching_sha2_password |
| % | root | caching_sha2_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | caching_sha2_password |
+-----------+------------------+-----------------------+
6 rows in set (0.00 sec)
mysql>
因為 caching_sha2_password ，所以使用密碼登錄是不行的，需要修改
7.3 修改plugin
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'admin_DEV123';
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'admin_DEV123';
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user,plugin from user;
+-----------+------------------+-----------------------+
| host | user | plugin |
+-----------+------------------+-----------------------+
| % | lyc | caching_sha2_password |
| % | root | mysql_native_password |
| localhost | mysql.infoschema | caching_sha2_password |
| localhost | mysql.session | caching_sha2_password |
| localhost | mysql.sys | caching_sha2_password |
| localhost | root | caching_sha2_password |
+-----------+------------------+-----------------------+
6 rows in set (0.00 sec)
mysql>
7.4 刷新權限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql>
