====== SQL ======


===== Snippet =====
===== 创建数据库 & 同名用户 =====

替换这里的 test_user & test_pass

<code copy SQL [enable_line_numbers="true"]>-- 创建同名数据库
CREATE DATABASE IF NOT EXISTS `test_user`;

-- 创建用户（允许任意 IP 连接）
CREATE USER IF NOT EXISTS 'test_user'@'%' IDENTIFIED BY 'test_pass';

-- 授予该用户对同名数据库的全部权限
GRANT ALL PRIVILEGES ON `test_user`.* TO 'test_user'@'%';

-- 刷新权限使生效
FLUSH PRIVILEGES;</code>

===== 创建数据库 & 同名用户并授权 =====

<code copy SQL [enable_line_numbers="true"]>CREATE USER 'scribego'@'%' IDENTIFIED WITH sha256_password BY '***';

GRANT USAGE ON *.* TO 'scribego'@'%';

ALTER USER 'scribego'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

CREATE DATABASE IF NOT EXISTS `scribego`;

GRANT ALL PRIVILEGES ON `scribego`.* TO 'scribego'@'%';

GRANT ALL PRIVILEGES ON `scribego\_%`.* TO 'scribego'@'%';
</code>