# Instructions for running MYSQL docker container with NodeJS

## 1. Using MySQL Server

```sh
> docker run -p ${EXTERNAL_PORT}:3306 --name=${CONTAINER_NAME} -d mysql/mysql-server:latest

# Copy the password from below
> docker logs ${CONTAINER_NAME} 2>&1 | grep GENERATED

> docker exec -it ${CONTAINER_NAME} mysql -u root -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '${NEW_ROOT_PASSWORD}';

mysql> CREATE USER '${NEW_USER}'@'%' IDENTIFIED BY '${NEW_USER_PASSWORD}';

mysql> ALTER USER '${NEW_USER}'@'%' IDENTIFIED WITH mysql_native_password BY '${NEW_USER_PASSWORD}';

mysql> GRANT ALL PRIVILEGES ON *.* to '${NEW_USER}'@'%' WITH GRANT OPTION;

mysql> CREATE DATABASE ${DATABASE_NAME};

# Getting inside MYSQL container's console
> docker exec -it ${CONTAINER_NAME} mysql -u ${NEW_USER} -p
```

## 2. Using MySQL

```sh
> docker run --name ${CONTAINER_NAME} -v ${HOST_MYSQL_DATA_MOUNT_PATH}:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=${NEW_ROOT_PASSWORD} -e MYSQL_DATABASE=${DATABASE_NAME} -e MYSQL_USER=${NEW_USER} -e MYSQL_PASSWORD=${NEW_USER_PASSWORD} -p ${EXTERNAL_PORT}:3306 -d mysql

> docker exec -it ${CONTAINER_NAME} mysql -u root -p

mysql> ALTER USER '${NEW_USER}'@'%' IDENTIFIED WITH mysql_native_password BY '${NEW_USER_PASSWORD}';

mysql> GRANT ALL PRIVILEGES ON *.* to '${NEW_USER}'@'%' WITH GRANT OPTION;

# Getting inside MYSQL container's console
> docker exec -it ${CONTAINER_NAME} mysql -u ${NEW_USER} -p
```