目录

SQL

Snippet

创建数据库 & 同名用户

替换这里的 test_user & test_pass

SQL
  1. -- 创建同名数据库
  2. CREATE DATABASE IF NOT EXISTS `test_user`;
  3.  
  4. -- 创建用户（允许任意 IP 连接）
  5. CREATE USER IF NOT EXISTS 'test_user'@'%' IDENTIFIED BY 'test_pass';
  6.  
  7. -- 授予该用户对同名数据库的全部权限
  8. GRANT ALL PRIVILEGES ON `test_user`.* TO 'test_user'@'%';
  9.  
  10. -- 刷新权限使生效
  11. FLUSH PRIVILEGES;

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

SQL
  1. CREATE USER 'scribego'@'%' IDENTIFIED WITH sha256_password BY '***';
  2.  
  3. GRANT USAGE ON *.* TO 'scribego'@'%';
  4.  
  5. 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;
  6.  
  7. CREATE DATABASE IF NOT EXISTS `scribego`;
  8.  
  9. GRANT ALL PRIVILEGES ON `scribego`.* TO 'scribego'@'%';
  10.  
  11. GRANT ALL PRIVILEGES ON `scribego\_%`.* TO 'scribego'@'%';