docker-compose.yml
version: '3.3'
services:
mysql:
restart: always
image: mysql:8.0
container_name: mysql
ports:
- '3306:3306'
- '33060:33060'
environment:
- DEBUG=false
- MYSQL_DATABASE=baza
- MYSQL_USER=user
- MYSQL_PASSWORD=password
- MYSQL_ROOT_PASSWORD=password
volumes:
- ./mysql-datadir:/var/lib/mysql
- ./:/backup
- /etc/localtime:/etc/localtime:ro
docker exec -it mysql bash
mysql -u root -p
grant all privileges on *.* to 'user'@'%' with grant option;
mysql -u user -p
version: '3.3'
services:
mysql:
restart: always
image: mysql:8.0
container_name: mysql
ports:
- '3306:3306'
- '33060:33060'
environment:
- DEBUG=false
- MYSQL_DATABASE=baza
- MYSQL_USER=user
- MYSQL_PASSWORD=password
- MYSQL_ROOT_PASSWORD=password
volumes:
- ./mysql-datadir:/var/lib/mysql
- ./:/backup
- /etc/localtime:/etc/localtime:ro
docker exec -it mysql bash
mysql -u root -p
grant all privileges on *.* to 'user'@'%' with grant option;
mysql -u user -p
mysqldump -u user -p baza > /backup/baza.sql
Dump remote DB:
mysql -u user -p -h127.0.0.1
mysqldump -u user -p -h127.0.0.1 baza > baza.sql
Dump remote DB:
mysql -u user -p -h127.0.0.1
mysqldump -u user -p -h127.0.0.1 baza > baza.sql