mysql docker usage

1. Start a mysql container:

$docker run -p 3306:3306 --name mysql-server-1 -e MYSQL_ROOT_PASSWORD=welcome1 -v /scratch/cdctest/work/data/:/var/lib/mysql -d mysql

note: /scratch/cdctest/work/data/, the directory in docker host, used for data persistence.

2. Initialize mysql database:

$mysql -u root -p

Create a user named with cdctest
mysql> CREATE USER cdctest IDENTIFIED BY 'MyTest1@';
mysql> grant all privileges on *.* to cdctest@"%" with grant option;

mysql> flush privileges;

$mysql -u cdctest -p