| 用途 | 账号属性变更 |
|---|---|
| 语法 | ALTER USER 'u'@'host' 属性 … |
| 属性 | IDENTIFIED BY / ACCOUNT LOCK|UNLOCK / REQUIRE SSL / WITH 资源限制 |
常用修改
常用修改
ALTER USER 'app'@'%' IDENTIFIED BY 'NewStr0ng#Pass!';
ALTER USER 'app'@'%' ACCOUNT UNLOCK;
ALTER USER 'app'@'%' REQUIRE SSL;
ALTER USER 'app'@'%' WITH MAX_USER_CONNECTIONS 200 MAX_QUERIES_PER_HOUR 0;MAX_USER_CONNECTIONS 能防止单账号连接泄漏拖垮实例，是连接治理的兜底手段。