How to run MySQL database in a Docker
How to run MySQL database in a Docker container in Linux vm|step-by-step demo
with access from mysql workbench from window host
Setting up a MySQL database using Docker simplifies the process of database management, allowing you to create, configure, and manage your databases in isolated containers. This guide will walk you through the steps to set up a MySQL database using Docker commands .
```
docker pull mysql:latest
mkdir -p /opt/mysql/data
chmod -R 755 /opt/mysql/data
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password123 -v /opt/mysql/data:/var/lib/mysql -d mysql:latest
docker exec -it mysql bash
bash-5.1# mysql -u root -p
GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
CREATE DATABASE IF NOT EXISTS orgdb1;
USE orgdb1;
SHOW TABLES;
CREATE TABLE emp_test (
emp_id int NOT NULL PRIMARY KEY,
emp_name varchar(20),
sal int,
dept_name varchar(10)
);
DESCRIBE emp;
````