|------------------------------------------------- | General Information |------------------------------------------------- Official MySQL database container. It allows to set a database and username without using the console. MySQL is the world's most popular open source database. With its proven performance, reliability and ease-of-use, MySQL has become the leading database choice for web-based applications, covering the entire range from personal projects and websites, via e-commerce and information services, all the way to high profile web properties including Facebook, Twitter, YouTube, Yahoo! and many more. For more information and related downloads for MySQL Server and other MySQL products, please visit www.mysql.com. |------------------------------------------------- | Root Password |------------------------------------------------- This container creates by default a random root password on initial execution. Open Docker > MySQL Icon > Logs > Scroll down to "GENERATED ROOT PASSWORD" to find it. |------------------------------------------------- | Creating database dumps |------------------------------------------------- docker exec some-mysql sh -c 'exec mysqldump --all-databases -uroot -p"$MYSQL_ROOT_PASSWORD"' > /mnt/user/Backups/all-databases.sql |------------------------------------------------- | Restoring data from dump files |------------------------------------------------- docker exec -i some-mysql sh -c 'exec mysql -uroot -p"$MYSQL_ROOT_PASSWORD"' < /mnt/user/Backups/all-databases.sql |------------------------------------------------- | Configuration without a cnf file |------------------------------------------------- Many configuration options can be passed as flags to mysqld. This will give you the flexibility to customize the container without needing a cnf file. For example, if you want to change the default encoding and collation for all tables to use UTF-8 (utf8mb4) just append the following to the Post Arguments: --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci Here is a list of all Server System Variables -> https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html |------------------------------------------------- | Repository tags |------------------------------------------------- If you want to install a specific version of mysql, you can simply customize the repository. For example: mysql (is the same like mysql:latest) mysql:5.7 mysql:8.2.0
