This project contains a Ghost container which contains a MySQL-client to connect with a persistent MySQL container. Environment variables are used to create the database and make the connection.
$ git clone https://github.com/lvthillo/docker-ghost.git
$ cd docker-ghost-mysql
$ docker-compose up --build -d
Visit http://localhost or http://localhost/admin
Create a user
Verify if the user exists in MySQL
$ docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
55e5ccda1a7f lvthillo/ghost:1.20.0 "wait-for-it.sh mysq…" 3 minutes ago Up 3 minutes 0.0.0.0:80->2368/tcp ghost
1e51addc77b6 mysql:5.7 "docker-entrypoint.s…" 9 minutes ago Up 9 minutes 3306/tcp mysql
$ docker exec -it mysql bash
root@1e51addc77b6:/# mysql -ublog-user -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 79
Server version: 5.7.20 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| db |
+--------------------+
2 rows in set (0.00 sec)
mysql> use db;
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_db |
+------------------------+
| accesstokens |
| app_fields |
| app_settings |
| apps |
| brute |
| client_trusted_domains |
| clients |
| invites |
| migrations |
| migrations_lock |
| permissions |
| permissions_apps |
| permissions_roles |
| permissions_users |
| posts |
| posts_tags |
| refreshtokens |
| roles |
| roles_users |
| settings |
| subscribers |
| tags |
| users |
| webhooks |
+------------------------+
24 rows in set (0.00 sec)
mysql> SELECT name from users;
+------------+
| name |
+------------+
| Tim Cahill |
| Ghost |
+------------+
2 rows in set (0.00 sec)