TryGhost / TryGhost/ghost-docker

Host is not allowed to connect to this MySQL server

Open
#127 1 comment 3 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Shell
Stars
95
Forks
96
Avg merge
1d 1h
Merged PRs (30d)
32

Description

I receive the following exception after running podman compose up -d. Seems like the mysql init script isn't running?

[2026-02-06 23:46:34] INFO Ghost is running in production...
[2026-02-06 23:46:34] INFO Your site is now available on https://tdidb.com/
[2026-02-06 23:46:34] INFO Ctrl+C to shut down
[2026-02-06 23:46:34] INFO Ghost server started in 1.467s
[2026-02-06 23:46:34] ERROR Host '10.89.0.5' is not allowed to connect to this MySQL server

Host '10.89.0.5' is not allowed to connect to this MySQL server

"Unknown database error"

Error ID:
    500

Error Code:
    ER_HOST_NOT_PRIVILEGED

----------------------------------------

Error: Host '10.89.0.5' is not allowed to connect to this MySQL server
    at /var/lib/ghost/versions/6.17.0/node_modules/knex-migrator/lib/database.js:57:19
    at Packet.asError (/var/lib/ghost/versions/6.17.0/node_modules/mysql2/lib/packets/packet.js:740:17)
    at ClientHandshake.execute (/var/lib/ghost/versions/6.17.0/node_modules/mysql2/lib/commands/command.js:29:26)
    at Connection.handlePacket (/var/lib/ghost/versions/6.17.0/node_modules/mysql2/lib/base/connection.js:475:34)
    at PacketParser.onPacket (/var/lib/ghost/versions/6.17.0/node_modules/mysql2/lib/base/connection.js:93:12)
    at PacketParser.executeStart (/var/lib/ghost/versions/6.17.0/node_modules/mysql2/lib/packet_parser.js:75:16)
    at Socket.<anonymous> (/var/lib/ghost/versions/6.17.0/node_modules/mysql2/lib/base/connection.js:100:25)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)

[2026-02-06 23:46:34] WARN Ghost is shutting down
[2026-02-06 23:46:34] WARN Ghost has shut down
[2026-02-06 23:46:34] WARN Your site is now offline
[2026-02-06 23:46:34] WARN Ghost was running for a few seconds

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Reproduce the failure with podman compose up -d, then inspect the compose configuration and MySQL initialization behavior using the reported ER_HOST_NOT_PRIVILEGED error as the starting point. Done means the initialization grants the expected access and Ghost starts without the host-permission error.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
database, infrastructure
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
42/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.