连接到 Docker 中运行的 MySQL 容器，開啟權限

# 连接到 Docker 中运行的 MySQL 容器
sudo docker exec -it <your-container-name> mysql -u root -p

# 创建DATABASE 
CREATE DATABASE IF NOT EXISTS <db-name>;

# 创建新的用户
CREATE USER 'in_user'@'%' IDENTIFIED BY 'in_password';

# 更改密碼
ALTER USER 'in_user'@'%' IDENTIFIED BY 'new_password';

# 授予权限
GRANT ALL PRIVILEGES ON <db-name>.* TO 'in_user'@'%';

# 移除賦予的權限
REVOKE [權限列表] ON <db-name>.* FROM 'in_user'@'%';
# 權限列表：要移除的具體權限，如 ALL PRIVILEGES、SELECT、INSERT 等

# 重新加载权限
FLUSH PRIVILEGES;

---

Be the first one to support oldfesixsixsix.

---