# -  - #
# - List containers on server - #
sudo docker ps;

# - Include not running containers - #
sudo docker ps -a;


# -  - #
# - Show docker images - #
sudo docker images;


# -  - #
# - Pull MySql image - #
sudo docker pull mysql;


# -  - #
# - Run container from image - #
sudo docker run --name=MySQL_1 -e MYSQL_ROOT_PASSWORD=Administrator2 -d mysql;
sudo docker run --name=MySQL_2 -e MYSQL_ROOT_PASSWORD=Administrator2 -d mysql;

sudo docker run --name=MySQL_1a -e MYSQL_ROOT_PASSWORD=Administrator2 --publish 8306:3306 -d mysql;



# -  - #
# - Check container status - #
sudo docker ps;


# -  - #
# - Checkout logs - #
sudo docker logs MySQL_1;


# -  - #
# -  Find the IP of the container “IPAddress”- #
sudo docker inspect MySQL_1;


mysql -u root -pAdministrator2 -h 172.17.0.4





# -  - #
# - Pull phpmyadmin image - #
sudo docker pull phpmyadmin/phpmyadmin;


# -  - #
# - Run phpmyadmin image - #
sudo docker run --name myadmin -d --link MySQL_1:db -p 8383:83 phpmyadmin/phpmyadmin;
sudo docker run --name myadmin -d --link MySQL_2:db -p 8383:83 phpmyadmin/phpmyadmin;

sudo docker run --name myadmin_1a -d --link MySQL_1a:db -p 8383:80 phpmyadmin/phpmyadmin;
sudo docker run --name myadmin_1a -d --link MySQL_1a:db -p 8309:80 phpmyadmin/phpmyadmin;

# -  - #
# - Connect to MySQL_1 container - #
mysql -u root -pAdministrator2 -h 172.17.0.4


# -  - #
# - Stop container - #
sudo docker stop MySQL_1;
sudo docker stop myadmin;


# -  - #
# - Restart container - #
sudo docker restart MySQL_1;



# -  - #
# - Remove container - #
sudo docker rm MySQL_1;
sudo docker rm myadmin;



# -  - #
# - Redirect MySQL database - #
docker run --name=mysql1 \
--mount type=bind,src=/path-on-host-machine/my.cnf,dst=/etc/my.cnf \
--mount type=bind,src=/path-on-host-machine/datadir,dst=/var/lib/mysql \
-d mysql/mysql-server:tag




mysql -h localhost -P 3306 --protocol=tcp -u root
mysql -u root -h 192.168.1.101 -P 3306 --protocol=tcp
mysql -u root -pAdministrator2 -h 172.17.0.6


# -  - #
# - Create is_derayo user - #
CREATE USER 'is_derayo'@'localhost' IDENTIFIED BY 'Administrator2';
GRANT ALL PRIVILEGES ON *.* TO 'is_derayo'@'localhost' WITH GRANT OPTION;
CREATE USER 'is_derayo'@'%' IDENTIFIED BY 'Administrator2';
GRANT ALL PRIVILEGES ON *.* TO 'is_derayo'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

use mysql;
SELECT host, user, plugin, authentication_string FROM user ORDER BY user;



ALTER USER 'is_derayo'@'%' IDENTIFIED WITH mysql_native_password BY 'Administrator2';
ALTER USER 'is_derayo'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Administrator2';
SELECT host, user, plugin, authentication_string FROM user ORDER BY user;



# -  - #
# - Connect to MySQL container - #
mysql -u root -pAdministrator2 -h 192.168.1.101 -P 8306
mysql -u root -pAdministrator2 -h 192.168.1.101 -P 8306 --protocol=tcp

mysql -u root -pAdministrator2 -h 192.168.1.101 -P 8306 -e 'SHOW DATABASES;';
mysql -u root -pAdministrator2 -h 192.168.1.101 -P 8307 -e 'SHOW DATABASES;';
mysql -u root -pAdministrator2 -h 192.168.1.200 -P 8301 -e 'SHOW DATABASES;';

mysql -u root -pAdministrator2 -h 192.168.1.200 -P 8301 -e 'CREATE DATABASE MySQL_200;';
mysql -u is_derayo -pAdministrator2 -h 192.168.1.100 -P 8303 -e 'CREATE DATABASE MySQL_100;';
mysql -u is_derayo -pAdministrator2 -h 192.168.1.100 -P 8304 -e 'CREATE DATABASE MySQL_200;';

mysql -u root -pAdministrator2 -h 192.168.1.200 -P 8301 -e 'USE mysql; SELECT host, user, plugin, authentication_string FROM user ORDER BY user;';


mysql -u is_derayo -pAdministrator2 -h 192.168.1.20 -P 8301 -e 'USE mysql; SELECT host, user, plugin, authentication_string FROM user ORDER BY user;';
mysql -u is_derayo -pAdministrator2 -h 192.168.1.20 -P 8302 -e 'USE mysql; SELECT host, user, plugin, authentication_string FROM user ORDER BY user;';

mysql -u is_derayo -pAdministrator2 -h 192.168.1.20 -P 8302 -e 'SHOW DATABASES;';

mysql -u is_derayo -pAdministrator2 -h 192.168.1.20 -P 8301 -e 'CREATE DATABASE MySQL_100;';
mysql -u is_derayo -pAdministrator2 -h 192.168.1.20 -P 8301 -e 'CREATE DATABASE MySQL_200;';
mysql -u is_derayo -pAdministrator2 -h 192.168.1.20 -P 8301 -e 'SHOW DATABASES;';