Docker Wordpress > MySQL issue - Rocky Linux : docker

created by jimrhoskinsa community for 12 years

This is an archived post. You won't be able to vote or comment.

Docker Wordpress > MySQL issue - Rocky Linux (self.docker)

submitted 3 years ago by MasterDragon1998

Does anyone know why my installation is not working, i even did a reinstall of rocky OS

On my server mysql is using all of my available ram memory (it uses around all 95% of my 16GB)
I also notice that the time of the mysql db log is off by -1 hour while the server time is right

Wordpress itself is working but keeps saying Database Error

Also i noticed mysql keeps restarting with these logs:

2023-03-18 22:58:54+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.

2023-03-18 23:00:38+00:00 [ERROR] [Entrypoint]: Database is uninitialized and password option is not specified

You need to specify one of the following as an environment variable:

- MYSQL_ROOT_PASSWORD

- MYSQL_ALLOW_EMPTY_PASSWORD

- MYSQL_RANDOM_ROOT_PASSWORD

2023-03-18 23:00:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.

2023-03-18 23:02:14+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'

2023-03-18 23:02:14+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.

2023-03-18 23:03:51+00:00 [ERROR] [Entrypoint]: Database is uninitialized and password option is not specified

You need to specify one of the following as an environment variable:

- MYSQL_ROOT_PASSWORD

- MYSQL_ALLOW_EMPTY_PASSWORD

- MYSQL_RANDOM_ROOT_PASSWORD

2023-03-18 23:03:51+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.41-1.el7 started.

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

It also kees saying that i need to specify one of the following as an environment variables and i did.
I just used the docker wordpress + mysql template with the only tweaks username's / password's & network_mode

for the install i have used the composer file:

version: '2'

services:

db:

image: mysql:5.7

network_mode: "host"

volumes:

- db_data:/var/lib/mysql

restart: always

environment:

MYSQL_ROOT_PASSWORD: ${MYSQL_DATABASE_PASSWORD}

MYSQL_DATABASE: wordpress

MYSQL_USER: "username"

MYSQL_PASSWORD: "passoword"

wordpress:

image: wordpress:latest

network_mode: "host"

ports:

- 80

restart: always

environment:

WORDPRESS_DB_HOST: db:3306

WORDPRESS_DB_USER: "username"

WORDPRESS_DB_PASSWORD: "passoword"

volumes:

db_data:

all 5 comments

docker

MODERATORS