MySQL 的 vsql_oauth2 扩展

INSTALL EXTENSION vsql_oauth2;

SELECT EXTENSION_NAME
FROM INFORMATION_SCHEMA.EXTENSIONS
WHERE EXTENSION_NAME = 'vsql_oauth2';

+----------------+
| EXTENSION_NAME |
+----------------+
| vsql_oauth2    |
+----------------+

CREATE USER 'analyst'@'%' IDENTIFIED WITH vsql_oauth2;

SELECT user, plugin FROM mysql.user WHERE user = 'analyst';

+---------+-------------+
| user    | plugin      |
+---------+-------------+
| analyst | vsql_oauth2 |
+---------+-------------+

CREATE USER 'oidc_user'@'%' IDENTIFIED WITH vsql_oauth2;
CREATE USER 'alice@example.com' ACCOUNT LOCK;
GRANT SELECT ON app.* TO 'alice@example.com';
GRANT PROXY ON 'alice@example.com' TO 'oidc_user'@'%';