jellyfina/mysql repository overview

docker run -it --name mysql --restart=always -p 3306:3306 -e MYSQL_ROOT_PASSWORD=aa23456 -e MYSQL_DATABASE=testdb -e MYSQL_USER=testuser -e MYSQL_PASSWORD=aa123456 -v /root/mysql:/var/lib/mysql jellyfina/mysql

version: '3.3'

services:
  mysql:
    image: mysql
    container_name: mysql
    environment:
      MYSQL_ROOT_PASSWORD: aa23456
      MYSQL_DATABASE: testdb
      MYSQL_USER: testuser
      MYSQL_PASSWORD: aa123456
    ports:
      - "3306:3306"
    volumes:
      - /root/mysql:/var/lib/mysql
    network_mode: bridge

volumes: 
  mysql_data:

docker exec -it mysql sh

mysqladmin -u root password "aa23456"

mysql -h localhost -u root -p

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

CREATE DATABASE test1;

GRANT ALL PRIVILEGES ON test.* TO 'newuser'@'localhost';

GRANT ALL PRIVILEGES ON test.* TO 'newuser'@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'aa23456';

FLUSH PRIVILEGES;

mysqldump -u root -p test > test_backup.sql

mysql -u root -p test < test_backup.sql