概述

|------------------------------------------------- | 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

运行时参数

网络: bridge
外壳: sh
特权: false
额外参数: --user=99:100 --memory=2G --restart=unless-stopped

模板配置

MYSQL_TCP_PORTPorttcp

MYSQL_TCP_PORT

目标: 3306
默认值: 3306

Generate Random PasswordVariable

Set to yes, to generate a random root password. The generated password will be printed to the logs (Docker > MySQL Icon > Logs).

目标: MYSQL_RANDOM_ROOT_PASSWORD
默认值: yes|

Database NameVariable

This variable is optional and allows you to specify the name of a database to be created on image startup. If a user/password was supplied (see below) then that user will be granted superuser access (corresponding to GRANT ALL) to this database.

目标: MYSQL_DATABASE
默认值: MYSQL_DATABASE

Database UserVariable

These variables are optional, used in conjunction to create a new user and to set that user's password. This user will be granted superuser permissions (see above) for the database specified by the MYSQL_DATABASE variable. Both variables are required for a user to be created. Do note that there is no need to use this mechanism to create the root superuser, that user gets created by default with the password specified by the MYSQL_ROOT_PASSWORD variable.

目标: MYSQL_USER
默认值: MYSQL_USER

Database PasswordVariable

目标: MYSQL_PASSWORD
默认值: MYSQL_PASSWORD

DataPathrw

目标: /var/lib/mysql
默认值: /mnt/cache/appdata/mysql/data

LogsPathrw

目标: /var/log/mysql
默认值: /mnt/cache/appdata/mysql/logs

Root PasswordVariable

Generate Random Password must be empty if you like to set your own Root Password! This variable specifies the password that will be set for the MySQL root superuser account.

目标: MYSQL_ROOT_PASSWORD

MySQL configuration filePathrw

The default configuration for MySQL can be found in /etc/mysql/my.cnf, which may !includedir additional directories such as /etc/mysql/conf.d or /etc/mysql/mysql.conf.d. Please inspect the relevant files and directories within the mysql image itself for more details. This will start a new container where the MySQL instance uses the combined startup settings from /etc/mysql/my.cnf and /etc/mysql/conf.d/config-file.cnf, with settings from the latter taking precedence.

目标: /etc/mysql/conf.d
默认值: /mnt/cache/appdata/mysql/conf.d

MySQL unique start scriptsPathrw

When you run a MySQL container, it checks if MySQL directory /var/lib/mysql exist or not. If the directory doesn't exist (running it the first time), it will run your SQL files.

目标: /docker-entrypoint-initdb.d
默认值: /mnt/cache/appdata/mysql/initdb