If you also set the MYSQL_DATABASE variable, your new user account will automatically be granted all privileges on the newly created database.

MYSQL_USER and MYSQL_PASSWORD – Create a new initial user account, separately to the root user.

MYSQL_DATABASE – The name of a database schema to create when the server initializes for the first time.

Set these variables to automatically provision a new empty database and user account: The MySQL Docker images support optional environment variables that let you manage the first-run database setup. Automatically Creating A Database and User You’ll be able to connect using port 3306 on the MySQL container’s hostname (this matches the service name defined in your Compose file). Both containers will exist in the same Docker network. Define another service for the new container. If you need to connect from another Docker container, it’s best to use Docker Compose. This provides the full MySQL command-line interface, so you can use all the familiar commands and flags.

You can gain an interactive MySQL shell by attaching to the container and running the mysql command.

RELATED: How to Install Docker and Docker Compose on Linux Connecting to MySQL You can start MySQL using MYSQL_ROOT_PASSWORD=secure docker-compose up -d. Writing a docker-compose.yml file is more maintainable.

The docker run command can quickly become lengthy, especially if you have complex configuration requirements. RELATED: How to Use Docker to Containerize PHP and Apache Docker Compose Check for a line that contains ready for connections. You can check if the database is up by running docker logs my-mysql. The MySQL first-run routine will take a few seconds to complete. Here’s how to run MySQL while satisfying these prerequisites: docker run -name my-mysql -e MYSQL_ROOT_PASSWORD=secret -v $HOME/mysql-data:/var/lib/mysql -d mysql:8.0 MySQL will refuse to initialize if this variable isn’t set. Use the MYSQL_ROOT_PASSWORD environment variable. You also need to set a password for the MySQL root user.

How to install docker on mac