gistfile1.txt

# Spin up a docker mysql server with remote access
docker run --name mysql-server  \
-p 3306:3306 -p 33060:33060  \
-e MYSQL_ROOT_HOST='%' -e MYSQL_ROOT_PASSWORD='root'   \
-d mysql/mysql-server:latest

# login into the machine and create a nav user with nav password

# connect
mysql -u root -p -h 0.0.0.0

# create
CREATE USER 'nav' IDENTIFIED BY 'nav';

# grant privileges
GRANT ALL on *.* to 'nav'@'%' identified by 'nav';

#flush privileges
FLUSH PRIVILEGES;


exit -> try connecting now with remote server address and credentials.