==> Create mysql container

docker run --name mysql57 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=1234 -d mysql/mysql-server:5.7

Container will be created successfully

Create a data base now:

# docker exec -it mysql57 bash

This command access the mysql container and allow to execute commands on database.

Inside a container, type:

# mysql -h localhost -u root -p

Remember, the password is 1234. First, we need to create a user for out-of-container access because root access is not allowed:

CREATE USER 'demo_java' IDENTIFIED BY 'java';

grant all on *.* to 'demo_java'@'%' identified by '1234';

FLUSH PRIVILEGES;

To create a database, paste DDL bellow:

CREATE DATABASE hello_java CHARACTER SET utf8 COLLATE utf8_general_ci;

show databases;

you can see hello_java db

use hello_java

Create tables and insert rows in the DB

CREATE TABLE Customers (CustomerName varchar(20),ContactName varchar(255),Address varchar(255),City varchar(255),PostalCode varchar(255),Country varchar(255)

);

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

VALUES ('John', 'Tom B', 'Skagen', 'Stava', '40', 'USA');

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)

VALUES ('CardinalJohn', 'Erichsen', 'S21', 'Stech', '4045', 'Belgium');

select * from Customers;

OR

Another way to start a database and automatic create a hello_java database and demo_java user:

docker run --name mysql57 -p 3306:3306 \

-e MYSQL_ROOT_PASSWORD=1234 \

-e MYSQL_USER=demo_java \

-e MYSQL_PASSWORD=1234 \

-e MYSQL_DATABASE=hello_java \

-d mysql/mysql-server:5.7

And repeat above steps for table and row creation.

Now steps to access db from eclipse

Create a maven project and add dependency in the pom.xml file

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>6.0.6</version>

</dependency>

Create a class

package com.qa.dbTest;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class DbtestDemo {

public static void main(String[] args) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException {

// TODO Auto-generated method stub

Connection con = DriverManager.getConnection("jdbc:mysql://34.71.212.58:3306/hello_java","demo_java", "1234");

/* String driver="com.mysql.cj.jdbc.Driver";

String userName="demo_java";

String password="1234";

Class.forName(driver).newInstance();

con=DriverManager.getConnection(dburl, userName, password);*/

System.out.println("connection established successfully");

Statement st= con.createStatement();

ResultSet rs= st.executeQuery("select * from Customers");

while(rs.next())

{

System.out.println("CustomerName: " + rs.getString("CustomerName"));

}

rs.close();

}

}

Execute the class.. Connection to you DB will be successfull.

package com.qa.dbTest;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class InsertData {

public static void main(String[] args) throws SQLException {

// TODO Auto-generated method stub

Connection con = DriverManager.getConnection("jdbc:mysql://34.123.119.97:3306/hello_java","demo_java", "1234");

System.out.println("connection established successfully");

PreparedStatement ps = con.prepareStatement("INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)\r\n" +

"VALUES ('Sonal2', 'Vishal2', 'S21245', 'Stecsdfsdh', '4045', 'Gurgaon')");

ps.executeUpdate();

con.close();

}

}