MySQL - My Awesome Moments

How To Install WordPress in Docker using Docker Compose

I follow How to install WordPress in Docker Tutorial and found it has error in its docker-compose.yml file. Besides, it didn’t tell how to access phpMyAdmin and WordPress.

I am completely newbie on Docker so it took me time to really understand.

For that reason, I copy the tutorial and improve and simplify it. So it is easier for newcomer to Docker.

How To Install WordPress in Docker Using Docker Compose?

Create a folder for your project

mkdir dockerwordpress

1	mkdir dockerwordpress

Create a docker-compose.yml file inside your folder

touch docker-compose.yml

1	touch docker-compose.yml

Copy this Configuration to Your docker-compose.ymlversion: '3.9'

services:
  mysql:
    image: mysql:8.0
    volumes:
      - mysql_data:/var/lib/mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: wordpress
      MYSQL_USER: wordpress
      MYSQL_PASSWORD: wordpress

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    depends_on:
      - mysql
    environment:
      PMA_HOST: mysql
      PMA_PORT: 3306
      PMA_ARBITRARY: 1
    restart: always
    ports:
      - 8183:80

  wordpress:
    depends_on:
      - mysql
    image: wordpress:latest
    ports:
      - "8020:80"
    restart: always
    environment:
      WORDPRESS_DB_HOST: mysql:3306
      WORDPRESS_DB_USER: wordpress
      WORDPRESS_DB_PASSWORD: wordpress
      WORDPRESS_DB_NAME: wordpress
    volumes:
      - ./wordpress:/var/www/html

volumes:
  mysql_data: {}

Copy this Configuration to Your docker-compose.ymlversion: '3.9'

services:

mysql:

image: mysql:8.0

volumes:

- mysql_data:/var/lib/mysql

restart: always

environment:

MYSQL_ROOT_PASSWORD: root

MYSQL_DATABASE: wordpress

MYSQL_USER: wordpress

MYSQL_PASSWORD: wordpress

phpmyadmin:

image: phpmyadmin/phpmyadmin

depends_on:

- mysql

environment:

PMA_HOST: mysql

PMA_PORT: 3306

PMA_ARBITRARY: 1

restart: always

ports:

- 8183:80

wordpress:

depends_on:

- mysql

image: wordpress:latest

ports:

- "8020:80"

restart: always

environment:

WORDPRESS_DB_HOST: mysql:3306

WORDPRESS_DB_USER: wordpress

WORDPRESS_DB_PASSWORD: wordpress

WORDPRESS_DB_NAME: wordpress

volumes:

- ./wordpress:/var/www/html

volumes:

mysql_data: {}

Run The Docker WordPress Installation

Run Docker Compose Command Same Location as Your docker-compose.yml

docker-compose up -d

1	docker-compose up -d

docker - wordpress run compose up — docker – wordpress run compose up

Access WordPress

http://localhost:8020/

1	http://localhost:8020/

Run the usual WordPress Installation

Database Configuration:

Database name: wordpress
Username: wordpress
Password: wordpress

Testing Your WordPress Installation in Docker

Check at phpMyAdmin

http://localhost:8183/

1	http://localhost:8183/

Server: <leave it empty>
Username: WordPress
Password: WordPress

docker phpmyadmin username and password wordpress

Check Inserted Data

docker - new post successfully inserted in database — docker – new post successfully inserted in database

Last Note

With this docker-compose configuration you can’t access to your local file system. So this another thing I need to find the solution.

Import SQL File into MySQL in XAMPP from Command Line in MacOS

To import SQL file in XAMPP MySQL, first has to go to XAMPP MySQL bin then do the command standard Mysql import command line.

XAMPP Path in MacOS

/Applications/XAMPP/bin

1	/Applications/XAMPP/bin

Command in Terminal

./mysql -u <username> -p <database_name> < <sql_file>

1	./mysql -u <username> -p <database_name> < <sql_file>

Example:

./mysql -u wanrazali -p property_price_trends < /Users/wanrazalimatsah/Downloads/Original/hd_postmeta.sql

1	./mysql -u wanrazali -p property_price_trends < /Users/wanrazalimatsah/Downloads/Original/hd_postmeta.sql

Access XAMPP 8.2.4 MySQL via Command Line in MacOS

You can access XAMPP 8.2.4 MySQL via command line in MacOS by following these steps.

1. Go to XAMPP 8.2.4 MySQL folder in MacOS

/Applications/XAMPP/xamppfiles/bin/

1	/Applications/XAMPP/xamppfiles/bin/

2. Type This Command

./mysql -u username -p

1	./mysql -u username -p

If successful, XAMPP will connect to MariabDB instead of MySQL

You can double check by getting all databases in the MariaDB.

show databases;

1	show databases;

macos xampp 8.2.4 mysql access via command line

MySQL Upload / Import Database via Command Line using Ubuntu 22

I imported / uploaded SQL database with file size of 210MB and 347MB via Ubuntu v22 terminal command line.

My MySQL version is: 8.0.32

The Command Line

sudo mysql databasename < file.sql

1	sudo mysql databasename < file.sql

How Long it took to Import The Data?

Below is the time it took to upload the data.

210MB: 20s
347MB: 1m30s

Macbook M1 MacOS Big Sur Error MySQL PhpMyAdmin When Login

I login to MySQL using phpMyAdmin with root account and it produced this error.

The server requested authentication method unknown to the client
mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

The server requested authentication method unknown to the client

mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]

mysqli_real_connect(): (HY000/2054): The server requested authentication method unknown to the client

Login root via terminal

I was able to login using my root password means something configuration is not correct.

When I googled, I found 2 solutions. I tried the first one but fail. So I documented the one that works with Macbook M1 MacOS Big Sur.

Update root Password via Terminal

mysql -u root -p

mysql&gt; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YouCanUseBackYourPassword';

mysql -u root -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YouCanUseBackYourPassword';

Login Again At Your phpMyAdmin

It should work by now using root and the updated password.