【Docker】コンテナイメージからMySQLのコンテナ作成し、DBアクセスしてみた

PS C:\Users\XXXXXX> docker pull mysql
Using default tag: latest
latest: Pulling from library/mysql
6e839ac3722d: Pull complete
ad912193ad5f: Pull complete
25d13d87fd8d: Pull complete
004d383c75ef: Pull complete
6d9bbc82a0b8: Pull complete
81fec07ea550: Pull complete
83357cb2d3a5: Pull complete
8ffe968b82c1: Pull complete
30dfd9a7ed57: Pull complete
35844ae33cbe: Pull complete
Digest: sha256:｛省略｝
Status: Downloaded newer image for mysql:latest
docker.io/library/mysql:latest

What's next:
    View a summary of image vulnerabilities and recommendations → docker scout quickview mysql
PS C:\Users\XXXXXX>

PS C:\Users\XXXXXX> docker images
REPOSITORY    TAG       IMAGE ID       CREATED         SIZE
mysql         latest    a82a8f162e18   4 weeks ago     586MB　　　　←今回の実行で追加
PS C:\Users\XXXXXX>

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag

docker run --name test-mysql -p 10000:3306 -e MYSQL_ROOT_PASSWORD=XXXXXXXXXX -d mysql

PS C:\Users\XXXXXX> docker run --name test-mysql -p 10000:3306 -e MYSQL_ROOT_PASSWORD=XXXXXX -d mysql
1a7d8e8b2df4c908717cc217c742e0ed02cf947155d49b43eeb4bc9be53d7d3e
PS C:\Users\XXXXXX>

PS C:\Users\XXXXXX> docker ps
CONTAINER ID   IMAGE     COMMAND                   CREATED         STATUS         PORTS                                NAMES
1a7d8e8b2df4   mysql     "docker-entrypoint.s…"   4 minutes ago   Up 4 minutes   33060/tcp, 0.0.0.0:10000->3306/tcp   test-mysql
PS C:\Users\XXXXXX>

docker exec -it test-mysql bash

PS C:\Users\XXXXXX> docker exec -it test-mysql bash
bash-5.1#

mysql -u root -p

bash-5.1# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 9.0.1 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

mysql> CREATE DATABASE test_db;
Query OK, 1 row affected (0.07 sec)

mysql> USE test_db;
Database changed
mysql> CREATE TABLE human (
    -> id INT NOT NULL PRIMARY KEY,
    -> name VARCHAR(50)
    -> );
Query OK, 0 rows affected (0.11 sec)

mysql> INSERT INTO human(id, name) values (1, "taro"), (2, "hanako");
Query OK, 2 rows affected (0.05 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql>

mysql> SELECT * FROM human;
+----+--------+
| id | name   |
+----+--------+
|  1 | taro   |
|  2 | hanako |
+----+--------+
2 rows in set (0.01 sec)

mysql>

mysql> exit
Bye
bash-5.1# exit
exit

What's next:
    Try Docker Debug for seamless, persistent debugging tools in any container or image → docker debug test-mysql
    Learn more at https://docs.docker.com/go/debug-cli/
PS C:\Users\XXXXXX>

PS C:\Users\XXXXXX> docker ps
CONTAINER ID   IMAGE     COMMAND                   CREATED        STATUS        PORTS                                NAMES
1a7d8e8b2df4   mysql     "docker-entrypoint.s…"   14 hours ago   Up 14 hours   33060/tcp, 0.0.0.0:10000->3306/tcp   test-mysql
PS C:\Users\XXXXXX>

import mysql.connector

cnx = mysql.connector.connect(
    user='root',
    password='XXXXXX',
    host='localhost',
    port='10000'
)
cursor = cnx.cursor()
cursor.execute('SELECT * FROM test_db.human')

for id, name in cursor:
    print(f'{id}: {name}')


cursor.close()

1: taro
2: hanako

PS C:\Users\XXXXXX> docker ps
CONTAINER ID   IMAGE     COMMAND                   CREATED        STATUS        PORTS                                NAMES
1a7d8e8b2df4   mysql     "docker-entrypoint.s…"   14 hours ago   Up 14 hours   33060/tcp, 0.0.0.0:10000->3306/tcp   test-mysql

PS C:\Users\XXXXXX> docker stop test-mysql
test-mysql
PS C:\Users\XXXXXX> docker ps
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES
PS C:\Users\XXXXXX>

PS C:\Users\XXXXXX> docker ps -a
CONTAINER ID   IMAGE         COMMAND                   CREATED        STATUS                      PORTS     NAMES
1a7d8e8b2df4   mysql         "docker-entrypoint.s…"   14 hours ago   Exited (0) 10 seconds ago             test-mysql
PS C:\Users\XXXXXX>

S C:\Users\XXXXXX> docker start test-mysql
test-mysql
PS C:\Users\XXXXXX> docker ps
CONTAINER ID   IMAGE     COMMAND                   CREATED        STATUS         PORTS                                NAMES
1a7d8e8b2df4   mysql     "docker-entrypoint.s…"   14 hours ago   Up 4 seconds   33060/tcp, 0.0.0.0:10000->3306/tcp   test-mysql

PS C:\Users\XXXXXX> docker stop test-mysql
test-mysql
PS C:\Users\XXXXXX> docker rm test-mysql
test-mysql
PS C:\Users\XXXXXX> docker rmi mysql:latest
Untagged: mysql:latest
Untagged: mysql@sha256:86cdfe832c81e39a89cfb63c3fde1683c41cc00ef91e67653c9c1df0ba80f454
Deleted: sha256:a82a8f162e188e0df15b0d2d90c6e9e973af8e88a6cb74b8052122ae5e02325c
Deleted: sha256:5da6d4af0083ef5a3c34a897318f812bf2287df1d20324662bb462d9adc9a9f4
Deleted: sha256:c2517597cb75237e131a560ff4fd06b26b9bbe2dc84351258385d20f6bb3d141
Deleted: sha256:87392ed73e360ff3cdf9cf6f83da99054fa43703d9c68e8ee1cb908defa6c27b
Deleted: sha256:652f8d3f70cb386cbaa61ed1dd578b6485ca5f5bea8dceedd02176657a57d700
Deleted: sha256:aeb66573c46a113dc637070d9b6e5ad1af5a9629c706271013b658a04532c643
Deleted: sha256:c103d3c7862eec5cfc0aa42df27e8ef2e441467c94a64e282d44171245497c33
Deleted: sha256:bfee82506d3915fd33091e987014bf0fa4fb5079b2c64f8c4c82cf9289b87096
Deleted: sha256:f829026b115edfb645697aa370a1dff76055ace8a213d83e559f65699d9555ce
Deleted: sha256:28ff378667a9659a8bafabb2a3cca8d125c66c1cd7f1e8ca2797cbf83e511960
Deleted: sha256:3cf436755aff907c2c6a6fd9202eab0da03f0b331f8d1363078a6534d95608a0
PS C:\Users\XXXXXX> 

PS C:\Users\XXXXXX> docker images
REPOSITORY    TAG       IMAGE ID       CREATED         SIZE
PS C:\Users\XXXXXX>