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

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

Server-Side Pagination with React-Table and Spring Boot JPA with H2 Database

Pagination is a common technique used to split large amounts of data into smaller, more manageable chunks. With server-side pagination, data is retrieved from the server in smaller batches, reducing the amount of data transferred over the network and improving application performance. React-Table provides a wide range of built-in features such as sorting, filtering, pagination, row selection, and column resizing. These features can be easily configured and customized to fit specific requirements. For example, you can customize the sorting behavior to handle multiple sorting criteria, or you can add custom filters to the table to handle complex data filtering scenarios. Additionally, React-Table provides a flexible API that allows developers to extend its functionality with custom hooks, plugins, and components. This means that you can easily add custom functionality to the table, such as exporting data to CSV or integrating with external data sources. In terms of styl...
Post a Comment
Read more