I am getting the following error after running my docker-compose script:
mysqli::real_connect(): (HY000/2002): No such file or directory.
I've looked at Getting error mysqli::real_connect(): (HY000/2002): No such file or directory when I try to access my project on live server for answers but the given solutions don't work for me.
My docker-compose script looks like this:
version: '3'
services:
# Database
db:
image: mysql:latest
volumes:
- database:/var/lib/mysql
restart: always
environment:
MYSQL_ROOT_PASSWORD: Password
MYSQL_DATABASE: wordpress
MYSQL_USER: wordpress
MYSQL_PASSWORD: Password
networks:
- wpsite
# phpMyAdmin
phpmyadmin:
depends_on:
- db
image: phpmyadmin/phpmyadmin:latest
restart: always
ports:
- '8080:80'
environment:
PMA_HOST: db
MYSQL_ROOT_PASSWORD: Password
networks:
- wpsite
volumes: ['./config:/etc/phpmyadmin/']
# Wordpress
wordpress:
depends_on:
- db
image: wordpress:latest
ports:
- '80:80'
restart: always
volumes: ['./wordpress:/var/www/html']
environment:
WORDPRESS_DB_HOST: db:3306
WORDPRESS_DB_USER: wordpress
WORDPRESS_DB_PASSWORD: Password
networks:
- wpsite
networks:
wpsite:
volumes:
database:
So far I've tried changing $cfg['Servers'][$i]['host'] = 'localhost'; in the /etc/phpmyadmin/config.inc.php to both $cfg['Servers'][$i]['host'] = '127.0.0.1'; and $cfg['Servers'][$i]['host'] = 'db';. Neither of these options fix the problem. I made sure they get changed properly after rerunning the script.