Install ghost with docker + MySQL 8 [New Install]

Picture for the post Install ghost with docker + MySQL 8 [New Install]

Ghost is dropping support for MySQL5 for the next major release. If you are thinking to install ghost 4.x.x via docker choosing MySQL 8 would be a wise decision to avoid issues with future updates of the ghost version.

Ghost is already pushing a notice to, those who are currently using MySQL 5 to upgrade the MySQL version

MySQL 8 Upgrade warning

Without further delay let's jump on to the tutorial. To install ghost with docker make sure you have docker & docker-compose installed in your system.

to install docker on your system follow the guide (We are using Ubuntu 20.04 for the tutorial)

How To Install and Use Docker on Ubuntu 20.04 | DigitalOcean
Docker is an application that simplifies the process of managing application processes in containers. In this tutorial, you’ll install and use Docker Commun…

Step 1: Creating the Docker Compose File & start the Container

Access to your Server via Terminal


Create a folder to contain the docker-compose.yaml & docker volumes.


Create a file called docker-compose.yaml into the folder, you have just created

nano docker-compose.yaml

& paste the following

version: '3'


    image: ghost:latest
    restart: always
      - 2368:2368
      - ./content:/var/lib/ghost/content
      database__client: mysql
      database__connection__host: db
      database__connection__user: root
      database__connection__password: mysqulrootp@ssworD
      database__connection__database: yourdomain_prodction
      mail__transport: SMTP
      mail__from: "YourSite <[email protected]>"
      mail__options__host: ""
      mail__options__port: 587
      mail__options__auth__user: "apikey"
      mail__options__auth__pass: "sendgrid_api_key"

    container_name: yourdomain_db
    image: mysql:latest
    command: mysqld --default-authentication-plugin=mysql_native_password
    restart: always
      MYSQL_ROOT_PASSWORD: mysqulrootp@ssworD
      - ./data:/var/lib/mysql

Adjust the container_name url databas__connection__pasword database__connection__databse & SendGrid API with your original credentials, Save the file by pressing Ctrl+O.

Now start the container. run the following command to start the container.

docker-compose up -d

Step 2: Configure Nginx Server Block

Make sure you have Nginx installed if not you can install Nginx by running the following command
sudo apt install nginx

Create a file in /etc/nginx/sites-available/ directory using the following command.

sudo nano /etc/nginx/sites-available/

& paste the following

server {
  listen 80;
  listen [::]:80;
  location / { return 301$request_uri; }
server {
  listen 443 ssl http2;
  listen [::]:443 ssl http2;

  ssl_protocols TLSv1.2;
  ssl_ciphers HIGH:!MEDIUM:!LOW:!aNULL:!NULL:!SHA;
  ssl_prefer_server_ciphers on;
  ssl_session_cache shared:SSL:10m;

  ssl_certificate /etc/ssl/domainn/cert.pem; #define your ssl cert path
  ssl_certificate_key /etc/ssl/domain/key.pem; #define your private key path

  location / {
    proxy_set_header Host $http_host;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header X-Forwarded-Proto $scheme;
    proxy_pass; #define the port as your container

Adjust the domain name & path to your SSL certificate 

Save the file by pressing Ctrl+O & exit

Next, we have to create a symlink of the file to sites-enabled directory.

sudo ln -s /etc/nginx/sites-available/ /etc/nginx/sites-enabled/

check the Nginx configuration

sudo nginx -t

restart Nginx

sudo systemctl restart nginx

Now your blog should be up & running. Hope this helps.

Spookey! Managed Ghost hosting

Soon we are launching Spookey! a Managed ghost platform. try Spookey for free for 60 day by joining the Beta Program. No Credit/Debit cards required

Join the Beta Program

Join the community

Join the Visioun Community Discord Server!
Check out the Visioun Community community on Discord - hang out with 1 other members and enjoy free voice and text chat.
Visioun Invitation Link