用户容器：docker 免root权限登陆的解决方案

sudo groupadd docker   #添加docker用户组
sudo gpasswd -a $USER docker   #将登陆用户加入到docker用户组中
newgrp docker   #更新用户组
docker ps  #测试docker命令是否可以使用sudo正常使用

$docker pull mysql:5.7

$docker network create -d bridge blog_network

 docker container run -it --rm --name mysql --network blog_network  -v $PWD/data/myscript/:/docker-entrypoint-initdb.d/ --env MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7

$docker exec -it mysql bash
#mysql -u root -p

Enter password: 
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 $ docker container run -it --detach --name mysql --network blog_network -p 3306:3306 -v $PWD/data/myscript/:/docker-entrypoint-initdb.d/ --env MYSQL_RANDOM_ROOT_PASSWORD=yes mysql:5.7
$ docker container logs mysql| grep 'GENERATED ROOT PASSWORD: ' | awk -F': ' '{print $2}'

ooli0OhMoo1Ieg1CeiYieSohleeVi1oh
$mysql -u root -p

mysql>update mysql.user set authentication_string=password('newpassword') where user='root' ;
mysql>flush privileges;
mysql>exit