https://www.itread01.com/content/1549041846.html
https://www.gushiciku.cn/pl/gg7a/zh-tw
SHOW DATABASES;
列出所有資料庫
create user 'root2'@'%' identified by 'youpassword';
grant all privileges on *.* to 'root2'@'%' with grant option;
# 查看登入 User 權限,以下語法效果皆相同。
SHOW GRANTS;
# 重新整理
FLUSH PRIVILEGES;
mysql.sql
/*************** 原文 ***************/
DROP DATABASE IF EXISTS gogs;
CREATE DATABASE IF NOT EXISTS gogs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
/*************** 修改為 *************/
DROP DATABASE IF EXISTS gogs;
CREATE DATABASE IF NOT EXISTS gogs CHARACTER SET utf8 COLLATE utf8_general_ci;
/*************** 結束 ***************/