創建db 、使用者

docker compose up -d mysql

# 连接到 Docker 中运行的 MySQL 容器
docker exec -it p1-mysql mysql -u root -p
Enter password: 

# 创建DATABASE 
mysql> CREATE DATABASE IF NOT EXISTS redmine_db;
Query OK, 1 row affected (0.01 sec)

# 创建新的用户
mysql> CREATE USER 'redmine_p1user'@'%' IDENTIFIED BY 'redmine_password';
Query OK, 0 rows affected (0.01 sec)

# 授予权限
mysql> GRANT ALL PRIVILEGES ON redmine_db.* TO 'redmine_p1user'@'%';
Query OK, 0 rows affected (0.01 sec)

# 查看当前有哪些DATABASE
mysql> show DATABASES;

# 重新加载权限
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

# 查看当前用户权限
mysql> SHOW GRANTS FOR 'redmine_p1user'@'%';
+----------------------------------------------------------------+
| Grants for redmine_p1user@%                                    |
+----------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'redmine_p1user'@'%'                     |
| GRANT ALL PRIVILEGES ON `redmine_db`.* TO 'redmine_p1user'@'%' |
+----------------------------------------------------------------+
2 rows in set (0.00 sec)

---

Be the first one to support oldfesixsixsix.

---