Public | Automated Build

Last pushed: 2 years ago
Short Description
Short description is empty for this repo.
Full Description

Supported tags and respective Dockerfile links

For more information about this image and its history, please see the relevant
manifest file
(docker-mysql)

What is MySQL?

MySQL is (as of March 2014) the world's second most widely used open-source
relational database management system (RDBMS). It is named after co-founder
Michael Widenius's daughter, My. The SQL phrase stands for Structured Query
Language.

MySQL is a popular choice of database for use in web applications, and is a
central component of the widely used LAMP open source web application software
stack (and other 'AMP' stacks). LAMP is an acronym for "Linux, Apache, MySQL,
Perl/PHP/Python." Free-software-open source projects that require a
full-featured database management system often use MySQL.

Oracle Corporation and/or affiliates own the copyright and trademark for MySQL.

wikipedia.org/wiki/MySQL

How to use this image

start a mysql instance

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=mysecretpassword -d mysql

This image includes EXPOSE 3306 (the mysql port), so standard container
linking will make it automatically available to the linked containers (as the
following examples illustrate).

connect to it from an application

docker run --name some-app --link some-mysql:mysql -d application-that-uses-mysql

... or via mysql

docker run -it --link some-mysql:mysql --rm mysql sh -c 'exec mysql -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD"'

Environment Variables

The MySQL image uses several environment variables which are easy to miss. While
not all the variables are required, they may significantly aid you in using the
image.

MYSQL_ROOT_PASSWORD

This is the one environment variable that is required for you to use the MySQL
image. This environment variable should be what you want to set the root
password for MySQL to. In the above example, it is being set to
"mysecretpassword".

MYSQL_USER, MYSQL_PASSWORD

These optional environment variables are used in conjunction to set both a MySQL
user and password, which will subsequently be granted all permissions for the
database specified by the optional MYSQL_DATABASE variable. Note that if you
only have one of these two environment variables, then neither will actually do
anything - these two are meant to be used in conjunction with one another. When
these variables are used, it will create a new user with the given password in
the MySQL database - there is no need to specify MYSQL_USER with root, as
the root user already exists in the default MySQL and the password is
controlled by MYSQL_ROOT_PASSWORD.

MYSQL_DATABASE

This optional environment variable denotes the name of a database to create. If
a user/password was supplied (via the MYSQL_USER and MYSQL_PASSWORD
environment variables) then that user account will be granted (GRANT ALL)
access to this database.

Caveats

If there is no database when mysql starts in a container, then mysql will
create the default database for you. While this is the expected behavior of
mysql, this means that it will not accept incoming connections during that
time. This may cause issues when using automation tools, such as fig, that
start several containers simultaneously.

Supported Docker versions

This image is officially supported on Docker version 1.4.1.

Support for older versions (down to 1.0) is provided on a best-effort basis.

User Feedback

Issues

If you have any problems with or questions about this image, please contact us
through a GitHub issue.

You can also reach many of the official image maintainers via the
#docker-library IRC channel on Freenode.

Contributing

You are invited to contribute new features, fixes, or updates, large or small;
we are always thrilled to receive pull requests, and do our best to process them
as fast as we can.

Before you start to code, we recommend discussing your plans
through a GitHub issue, especially for more ambitious
contributions. This gives other contributors a chance to point you in the right
direction, give you feedback on your design, and help you find out if someone
else is working on the same thing.

Docker Pull Command
Owner
guoyukun
Source Repository

Comments (0)