Read Learn Code

One response to “Cloud”

1. 

   Pankaj Sonani

   May 11, 2018 at 3:42 pm

   How to run and use MYSQL from docker

   First download your docker version such Docker for Linux, Mac, Windows

   If you install docker for Mac or Windows – there will be no virstual Machine

   MAC :- xhyve – this VM uses the hypervisor framworks brhave like virtual Machine
   Windoes : – uses hyper-V virtual Machine

   Note:- now make sure with – docker-machine ls if you do not see default Machine than use localhost insted of docker virtual Machine IP.

   There is Docker Tools
   Docker Client
   Docker Machine
   Docker Compose
   Docker Kitematic
   Boot2Docker ISO
   VirtalBox

   After installation Run MySQL

   docker run –name container_NAME -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=DB_Name -p 3306:3306 -d mysql

   Or use Dockerfile to create on

       FROM centos:latest
   
       MAINTAINER Pankaj Sonani
   
       # Install latest updates
       RUN apt-get update
       RUN apt-get upgrade -y
   
       # Install mysql client and server
       RUN DEBIAN_FRONTEND=noninteractive apt-get -y install mysql-client mysql-server curl
   
       # To access MySQL from Host OS
       RUN sed -i -e"s/^bind-address\s*=\s*127.0.0.1/bind-address = 0.0.0.0/" /etc/mysql/my.cnf
   
       # Install database
       ADD ./database.sql /var/db/database.sql
   
       # Set Standard settings
       ENV user dbuser
       ENV password dbpassword
       ENV url file:/var/db/database.sql
       ENV right READ
   
       # Install starting script
       ADD ./start-database.sh /usr/local/bin/start-database.sh
       RUN chmod +x /usr/local/bin/start-database.sh
   
      # expose MySQL port to host OS
       EXPOSE 3306
   
       CMD ["/usr/local/bin/start-database.sh"]
   

   LikeLike

   Reply