Question Using Docker Wordpress with in Plesk created database

[papak]

Hi,

We tried to use Docker with empty created database in Plesk. We added under Wordpress Docker setting Environment variables like:

WORDPRESS_DB_HOST
WORDPRESS_DB_NAME
WORDPRESS_DB_USER
WORDPRESS_DB_PASSWORD

and we tried as WORDPRESS_DB_HOST: localhost:3306 or IP.ADDRESS:3306 but Wordpress refuse any connections. Instead try to connect to the unknown IP address:

MySQL Connection Error: (1045) Access denied for user 'papak_wptestuser'@'172.17.0.2' (using password: YES)

Any hint what could be wrong is appreciated.

Thanks in advance.

Regards

 

[VNick]

It's really simple.

1. Make sure your MySQL instance is available for "external" world. By default Plesk configures MySQL to listen only on loopback for security reasons.
   You may check which IPs your MySQL instance is bound to using the following command: netstat -tulnap | grep 3306
   To reconfigure MySQL to listen on all interfaces run the following command: plesk sbin mysqlmng --bind-address all
2. Use either internal host IP on docker0 interface (usually 172.17.0.1) or external server IP as value of WORDPRESS_DB_HOST

That should be enough to get it working.