CREATE DATABASE IF NOT EXISTS `myapp_dev` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS `myapp_test` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

--- 创建专用用户

CREATE USER IF NOT EXISTS 'myapp_user'@'%' IDENTIFIED BY 'devpassword';
GRANT ALL PRIVILEGES ON `myapp_dev`.* TO 'myapp_user'@'%';
GRANT ALL PRIVILEGES ON `myapp_test`.* TO 'myapp_user'@'%';
FLUSH PRIVILEGES;

USE `myapp_dev`;