Skip to main content

Beginner's Guide: Installing and Accessing a Relational Database using Docker

Installing a Relational Database for Beginner Developers using Docker

Docker is a popular containerization platform used by developers to easily package, deploy, and run applications across different environments. With Docker, developers can create lightweight and portable containers that can be easily deployed on any system with Docker installed.

One of the popular use cases for Docker is to run a relational database like MySQL or PostgreSQL. In this blog post, we will guide you on how to install Docker, run a MySQL database using Docker, and access it from the host system using both GUI and command-line interfaces.

Prerequisites

Before we get started, you need to make sure you have the following prerequisites installed on your system:

Installing MySQL using Docker

Once you have Docker installed on your system, you can use the following steps to install MySQL using Docker:

  1. Open a terminal or command prompt and enter the following command to download the MySQL Docker image:
docker pull mysql
  1. After the download is complete, run the following command to create a new container and start the MySQL server:
docker run -d --name mysql-container -e MYSQL_ROOT_PASSWORD=password mysql

In this command, we are creating a new Docker container with the name mysql-container and setting the root password for the MySQL server to password.

  1. Once the container is running, you can use the following command to access the MySQL server from the command-line interface:
docker exec -it mysql-container mysql -p

This command will start the MySQL command-line interface and prompt you to enter the root password you set in step 2.

Accessing MySQL from Host System

To access the MySQL server from the host system, you can use one of the following methods:

Method 1: Command-line Interface

You can use the following command to access the MySQL server from the command-line interface on the host system:

mysql -h 127.0.0.1 -u root -p

This command will connect to the MySQL server running inside the Docker container on the host system.

Method 2: GUI Interface

You can also use a GUI tool like MySQL Workbench to access the MySQL server running inside

Comments

Post a Comment

Popular posts from this blog

JSP page directives

A jsp page directive looks like this: <%@ directive attribute="value" %> I am not gonna explain each and every page directives here . I would like to discuss about two page directives  which is import and include. First of all consider the import directive . The following simple program illustrate the use of import page directive: The output would be something looks like this: <%@ page language="java" contentType="text/html; charset=UTF-8"     pageEncoding="UTF-8"%>  <%@ page import="java.util.Date" %>   //page directive <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Jsp Basics</title> </head> <body> <%=new Date() %> </body> </html> Tue Nov 12 17:42:34 I...
1 comment
Read more

a simple example for jdbc PreparedStatement

a simple example for PreparedStatement package basics.in.java.blogspot.in; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Main { private static final String USERNAME="root"; private static final String PASSWORD=""; private static final String CONN_STRING="jdbc:mysql://localhost/basicsinjavablogspot"; public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("com.mysql.jdbc.Driver"); Connection conn=null; Statement stmt=null; ResultSet rs=null; try { conn= DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD); System.out.println("database connection successful"); //stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); String sql="select * fr...
1 comment
Read more