docker安装mysql

docker pull mysql
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql

遇到Cannot connect to the Docker daemon at unix:///var/run/docker.sock. Is the docker daemon running?问题，执行下重启docker服务

service docker restart

遇到ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
问题

docker exec -it mysql /bin/bash
mysql -uroot -p
alter user 'root'@'%' identified with mysql_native_password by '123456';