Running MySQL inside docker

On a Cpanel Server with an old version of PHP, one of the applications requires MySQL 5.6 to work. Since the PHP version is no longer supported, updating MySQL using WHM will upgrade PHP to one of the supported versions, that may break existing sites. So I decided to install MySQL inside docker.

First create a folder for MySQL docker to store data.

Now run

For MairaDB 10.1, run

Here I used “KqAtPd3BpyKjQ” as the password, replace it with your password.

-p 3307:3306 -> tell docker to map port 3306 inside the docker container to port 3307 on host machine.

This will pull MySQL docker image and start it.

Once it finished downloading, you can check if it is running with the command

To connect to MySQL use

Auto Start on Boot

To start the container on boot, you can run

Or use /etc/rc.local, this may not work with newer versions of Ubuntu/debian

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *