Mysql on CentOS 7: Reset Passwd, Run Docker, Nginx-Stream

Docker

https://hub.docker.com/_/mysql

Enable only localhost: 127.0.0.1:3306

docker run -d \
--name mysql:5.7 \
--restart always \
-p 127.0.0.1:3306:3306 \
-v ~mysql:/var/lib/mysql \
-e MYSQL_ROOT_PASSWORD=$MYSQL_ROOT_PASSWORD \
mysql:5.7

Work with Nginx Stream : 3306 or 3316

3306 same with localhost
3316 change to a new port

/etc/nginx/nginx.conf

stream {
	server {
		listen 3306  so_keepalive=on;
       	proxy_connect_timeout 1s;
       	proxy_timeout 3s;
		# docker-mysql-1
       	proxy_pass 127.0.0.1:3316; 
    }
}

http {
	##
	# Basic Settings
	##
	...
}

Download

https://dev.mysql.com/downloads/repo/yum/
Red Hat Enterprise Linux 7