替换这里的 test_user & test_pass

SQL

-- 创建同名数据库
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;

SQL

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'@'%';