How to install MySQL in docker

By Computer Geeks -

Step 1: Pull mysql image

MySQL can be of any version, but I chose 5.6 for setup

$ sudo docker pull mysql/mysql-server:5.6
To pull the latest version
$ sudo docker pull mysql/mysql-server

Step 2: Start and config MySQL

Copy IMAGE_ID

$ sudo docker images

To create and run MySQL first time

$ sudo docker run --name mysql-5.6 -p 52000:3306 -e MYSQL_ROOT_PASSWORD=yourpassword -d IMAGE_ID

Description

--name => container name (can be anything)
-p  => external port : internal port

-e  => Environment variables (MYSQL_ROOT_PASSWORD)

-d  => Detached mode

Step 3: Check the mysql process status

$ sudo docker ps

To enter the MySQL server

$ sudo docker exec -it CONTAINER_ID bash
$ mysql -uroot -pyourpassword

 After initial container creation to run MySQL copy the CONTAINER_ID

$ sudo docker container ls -a

To start

$ sudo docker start CONTAINER_ID
To connect using external MySQL first grant privileges
$ mysql -P52000 -uroot -ppassword

Comments

Post a Comment

Popular posts from this blog

How to install Apache Tomcat in Ubuntu

By Mystique writer -
This post will describe how to install and configure Apache Tomcat. Apache Tomcat is a Servlet Container for Java-based Web Application. It is an open source software developed by Apache Software Foundation. It has three major Components Catalina (Servlet Container) Coyote (HTTP connector) Jasper (JSP engine) Software Version used in this post were as follows: Tomcat v9.08, Ubuntu 18.04 and Java JDK Step 1  Install Java Step 2 Create Tomcat User Step 3 Install Tomcat Step 4 Configure Tomcat Step 5 Manage Credentails Step 6 Start Tomcat ----------------------------------- STEP 1 : INSTALLING JAVA If Java JDK is not available install it. First, update the package index $ sudo apt-get update Then install Java JDK $ sudo apt-get install default-jdk STEP 2 : CREATE TOMCAT USER Create new tomcat group $ sudo groupadd tomcat  Create tomcat user with a home directory where we can install tomcat(/opt/tomcat) $ sudo useradd -s /bin/false -g groupname -d direc...
Read more

How to install MRTG on UBUNTU

By Mystique writer -
How to install MRTG on UBUNTU ---------------------------------------------- This post will describe how to install and configure MRTG( Multi Router Traffic Grapher )  which is a free software for monitoring and measuring the traffic load on network links. It helps the use the network traffic load over time in a graphical form.  Software Version used in this post were as follows: Ubuntu 18.04 SNMP v3 MRTG-2.17.4 Step 1 Install SNMP Step 2 Configure SNMPD Step 3 Install MRTG Step 4 Configure MRTG Step 5 Configure Apache Server Step 6 Finishing the Installations --------------------------------------------- STEP 1 : INSTALLING SNMP sudo apt-get update sudo apt-get install snmp sudo apt-get install snmpd STEP 2  : CONFIGURE SNMPD sudo nano /etc/snmp/snmpd.conf Change # Listen for connections from the local system only agentAddress udp:127.0.0.1:161 # Listen for connections on all interfaces (both IPv4 *and* IPv6) #agentAddress udp:161,udp6:[::1]:161...
Read more

How to install MongoDB in Ubuntu

By Mystique writer -
How to install MongoDB in Ubuntu --------------------------------------------- This post will describe how to install and configure MongoDB. MongoDB is  an open source document database and of type no sql. It stores data in the form of JSON( JavaScript Object Notation ) as a combination of documents and collection. It is highly scable and performance Software Version used in this post were as follows: MongoDB v3.6 and Ubuntu 18.04 Step 1 Creating Source list file Step 2 Installing MongoDB Step 3 Start the Mongo Deamon Step 4 Configure User for MongoDB -------------------------------------------------------------- STEP 1 : CREATING SOURCE LIST FILE Importing the public key sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 2930ADAE8CAF5059EE73BB4B58712A2291FA4AD5 Creating Souce list File echo "deb http://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.6 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.6.list STEP 2 : INSTALLING M...
Read more