mysql:sql

差别

这里会显示出您选择的修订版和当前版本之间的差别。

到此差别页面的链接

--- mysql:sql [2026/08/24 14:25] – bestony
+++ mysql:sql [2026/09/16 06:40] (当前版本) – bestony
@@ 行 18: / 行 18: @@
 -- 刷新权限使生效
 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>

/storage/data/attic/mysql/sql.1787581511.txt.gz · 最后更改: 2026/08/24 14:25 由 bestony