Last update: 2019-11-25

Installing MySQL in a container and creating a new database


MySQL is a very popular database engine. Usually, chances are you probably don't wake up one day wanting to install MySQL. Instead, you most likely have a software package which requires a MySQL database, and so adding this engine is a side effect, so you want to do it as quickly and efficiently as possible. Here we will cover how to install the database as a Docker container, and then how to create a new user and database for it.

The first thing to do is making sure Docker is installed. You can see my earlier post on how to do that.

Once Docker is installed, use this command to install MySQL, along with the root password you wish:

<bash>
docker run --name mysql -v /mysql_content:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=mypassword -d mysql:latest 

After that, you can enter the container and run a shell in order to start the mysql client:

<bash>
docker exec -it mysql /bin/bash
mysql -u root -p

Finally, you can create a new user and database according to the needs of the software package you're trying to install. Typically, these commands will do it:

<bash>
CREATE DATABASE mydb;
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypassword';
GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%';
FLUSH PRIVILEGES;
QUIT

That's it! Now all you need to do is configure the software package with the details you've entered. In order to find out which IP address to use for the MySQL container, you can use the docker inspect mysql command.


Looking to expand into the cloud? See what a certified AWS administrator can do for you.


 
© 2007-2019 Patrick Lambert - All resources on this site are provided under the MIT License - You can contact me at: contact@dendory.net