# dockerize # 02

### STEP # 01 

-> Open terminal & Initialize Variables

```
USERNAME=mohsin 
USERPASS=1234 
HOST=172.17.0.1 
ROOT_USER=root 
ROOT_PASSWORD=1234
CONTAINER_NAME='mysql-test' 
IMAGE_NAME='mysql/mysql-server'
```

### STEP # 02

-> Open terminal & Run the container

```
docker run -d -p 3306:3306 --name ${CONTAINER_NAME} -e MYSQL_ROOT_PASSWORD=${ROOT_PASSWORD} ${IMAGE_NAME} 
```

### STEP # 03

-> Initialize variables again (@Step # 01) then run command

```
docker exec -it ${CONTAINER_NAME} bash -l;
```

### STEP # 04

-> Initialize variables again (@Step # 01) then run command

```
mysql -u${ROOT_USER} -p${ROOT_PASSWORD} <<EOF
DROP USER IF EXISTS '${USERNAME}'@'${HOST}';
CREATE USER '${USERNAME}'@'${HOST}' IDENTIFIED BY '${USERPASS}';
GRANT ALL ON *.* TO '${USERNAME}'@'${HOST}'; 
FLUSH PRIVILEGES;
SELECT user, host FROM mysql.user;
EOF
```

{% file src="<https://4293196124-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZXQ5MYmuyeJlHOOR6RxA%2Fuploads%2FCHBTGbCZolcgOXFuG4hX%2Fmysql.sh?alt=media&token=f5d30eee-8bc4-4088-a038-5f55fab775a0>" %}