
pada settingan docker edit volume mysql config
version : '3'
services:
mysql:
image: mysql:5.7
container_name: new_mysql
environment:
MYSQL_USER: sandy
MYSQL_PASSWORD: password
MYSQL_ROOT_PASSWORD: password
MYSQL_DATABASE: default_schema
# command: --default-authentication-plugin=mysql_native_password
ports:
- 3306:3306
volumes:
- "./db_data:/var/lib/mysql"
- "./conf:/etc/mysql/conf.d"
networks:
- net
phpmyadmin:
image: phpmyadmin/phpmyadmin
container_name: phpmyadmin
links:
- mysql
environment:
PMA_HOST: mysql
PMA_PORT: 3306
PMA_ARBITRARY: 1
restart: always
ports:
- 80:80
networks:
- net
networks:
net:
docker.cnf [mysqld] skip-host-cache skip-name-resolve character-set-server = utf8 collation-server = utf8_unicode_ci mysql.cnf [mysql] mysqldump.cnf [mysqldump] quick quote-names max_allowed_packet = 16M