Docker创建MySQL

docker pull mysql:8.0.37

docker run -d \
  --name mydb \
  -e MYSQL_ROOT_PASSWORD=123456 \
  -p 3306:3306 \
  -v /data/mysql:/var/lib/mysql \
  mysql:8.0.37
  
 #进入容器
docker exec -it mydb mysql -u root -p
#创建admin权限，运行外部访问
CREATE USER 'admin'@"%" identified with mysql_native_password by '123456';
grant all on *.* to 'admin'@"%";
flush privileges;

show databases; 
use mysql;
show tables; 

SET NAMES utf8mb4;
select * from company;