MySQL --- Docker配置

基本步骤

1. Pull docker

docker pull mysql/mysql-server:version 

2. Run image

docker run --name your_name -v /local_path:/container_path -p 33061:3306 -e MYSQL_ROOT_PASSWORD=123321 -d mysql/mysql-server:version 

-p 3306代表容器内部mysql服务的端口好

3. exec docker

docker exec -it your_name bash 

4. 启动mysql

# 登陆mysql
mysql -u root -p password 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123321';

5. 添加远程新用户

# 创建用户
CREATE USER 'new_name'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
# 设置远程权限
GRANT ALL PRIVILEGES ON *.* TO 'new_name'@'%';