docker 安装 mysql8
拉取镜像:
docker pull mysql
运行命令:
docker run -d --name lzm-mysql8 -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Aa123456 mysql --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
创建账号:
1.添加用户 CREATE USER 'test' IDENTIFIED BY 'pwd'; 2.赋予权限 GRANT ALL PRIVILEGES ON *.* TO 'test'@'%'; 3.修改加密规则 ALTER USER 'test'@'%' IDENTIFIED BY 'pwd' PASSWORD EXPIRE NEVER; 4.更新一下用户密码 ALTER USER 'test'@'%' IDENTIFIED WITH mysql_native_password BY 'pwd'; 5.更新配置信息 FLUSH PRIVILEGES;