kevinpina/mysql-volumeless repository overview

$ sudo docker run -d --name mysql --restart=unless-stopped -p 3306:3306 kevinpina/mysql-volumeless:v1

User: root
Pass: 123456

        > ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
        > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_new_password';
        > GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
        > FLUSH PRIVILEGES;
        > SELECT user, host, plugin FROM mysql.user;

        $ mysql -u root -p  -h <REMOTE_IP>

	$ sudo docker cp mysql_bk.sql mysql-test:/

	mysql> mysql -u root -p my_database < mysql_bk.sql

	mysql> CREATE DATABASE my_database;
	mysql> CREATE USER 'mundoprensa'@'%' IDENTIFIED BY 'Sdf344dF';
	mysql> GRANT ALL PRIVILEGES ON *.* TO 'mundoprensa'@'%' WITH GRANT OPTION;
	mysql> FLUSH PRIVILEGES;

	mysql> ALTER USER 'user-name'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD';
	mysql> FLUSH PRIVILEGES;

	mysql> UPDATE mysql.user SET authentication_string = PASSWORD('NEW_USER_PASSWORD')
	mysql> WHERE User = 'user-name' AND Host = 'localhost';
	mysql> FLUSH PRIVILEGES;

	mysql> SET PASSWORD FOR 'user-name'@'%' = PASSWORD('NEW_USER_PASSWORD');
	mysql> FLUSH PRIVILEGES;

$ docker commit <ID_CONTAINER> my-new-image:lastest