How to launch a Docker container for MySQL

Question

Hi Guys,

I have configured Docker Engine in my Linux system. I want to launch one container for the MySQL database. How can I do that?

Answer 1

Hi@akhtar,

You can download MySQL image from the docker hub. But you need to check the document properly as MySQL database needs some environment variable. You can follow the below-given example.

[root@localhost ~]#  docker run -dit -e MYSQL_ROOT_PASSWORD=redhat -e MYSQL_USER=nadim -e MYSQL_PASSWORD=redhat -e MYSQL_DATABASE=mydatabase mysql:5.7
47024ab1114f5c9979179071b60c5110acea82e8f45fd7789f84c0963658b528
[root@localhost ~]#

To connect to the database your system should have MySQL command.

[root@localhost ~]# mysql -h 172.200.0.2 -u nadim -predhat
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.31 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>