[root@172 _data]# docker inspect nginx

# 掛載本地目錄
-v 本地目錄:容器內(nèi)目錄
# 掛載本地文件
-v 本地文件:容器內(nèi)文件

# 1.刪除原來(lái)的MySQL容器
docker rm -f mysql

# 2.進(jìn)入root目錄
cd ~

# 3.創(chuàng)建并運(yùn)行新mysql容器，掛載本地目錄
docker run -d \
  --name mysql \
  -p 3306:3306 \
  -e TZ=Asia/Shanghai \
  -e MYSQL_ROOT_PASSWORD=123 \
  -v ./mysql/data:/var/lib/mysql \
  -v ./mysql/conf:/etc/mysql/conf.d \
  -v ./mysql/init:/docker-entrypoint-initdb.d \
  mysql

# 4.查看root目錄，可以發(fā)現(xiàn)~/mysql/data目錄已經(jīng)自動(dòng)創(chuàng)建好了
ls -l mysql
# 結(jié)果：
總用量 4
drwxr-xr-x. 2 root    root   20 5月  19 15:11 conf
drwxr-xr-x. 7 polkitd root 4096 5月  19 15:11 data
drwxr-xr-x. 2 root    root   23 5月  19 15:11 init

# 查看data目錄，會(huì)發(fā)現(xiàn)里面有大量數(shù)據(jù)庫(kù)數(shù)據(jù)，說明數(shù)據(jù)庫(kù)完成了初始化
ls -l data

# 5.查看MySQL容器內(nèi)數(shù)據(jù)
# 5.1.進(jìn)入MySQL
docker exec -it mysql mysql -uroot -p123
# 5.2.查看編碼表
show variables like "%char%";
# 5.3.結(jié)果，發(fā)現(xiàn)編碼是utf8mb4沒有問題
+--------------------------+--------------------------------+
| Variable_name            | Value                          |
+--------------------------+--------------------------------+
| character_set_client     | utf8mb4                        |
| character_set_connection | utf8mb4                        |
| character_set_database   | utf8mb4                        |
| character_set_filesystem | binary                         |
| character_set_results    | utf8mb4                        |
| character_set_server     | utf8mb4                        |
| character_set_system     | utf8mb3                        |
| character_sets_dir       | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+

# 6.查看數(shù)據(jù)
# 6.1.查看數(shù)據(jù)庫(kù)
show databases;
# 結(jié)果，hmall是黑馬商城數(shù)據(jù)庫(kù)
+--------------------+
| Database           |
+--------------------+
| hmall              |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)
# 6.2.切換到hmall數(shù)據(jù)庫(kù)
use hmall;
# 6.3.查看表
show tables;
# 結(jié)果：
+-----------------+
| Tables_in_hmall |
+-----------------+
| address         |
| cart            |
| item            |
| order           |
| order_detail    |
| order_logistics |
| pay_order       |
| user            |
+-----------------+
# 6.4.查看address表數(shù)據(jù)
+----+---------+----------+--------+----------+-------------+---------------+-----------+------------+-------+
| id | user_id | province | city   | town     | mobile      | street        | contact   | is_default | notes |
+----+---------+----------+--------+----------+-------------+---------------+-----------+------------+-------+
| 59 |       1 | 北京     | 北京   | 朝陽(yáng)區(qū)    | 13900112222 | 金燕龍辦公樓   | 李佳誠(chéng)    | 0          | NULL  |
| 60 |       1 | 北京     | 北京   | 朝陽(yáng)區(qū)    | 13700221122 | 修正大廈       | 李佳紅    | 0          | NULL  |
| 61 |       1 | 上海     | 上海   | 浦東新區(qū)  | 13301212233 | 航頭鎮(zhèn)航頭路   | 李佳星    | 1          | NULL  |
| 63 |       1 | 廣東     | 佛山   | 永春      | 13301212233 | 永春武館       | 李曉龍    | 0          | NULL  |
+----+---------+----------+--------+----------+-------------+---------------+-----------+------------+-------+
4 rows in set (0.00 sec)