1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
MAX_CONNECTIONS_PER_HOUR
is a MySQL per-user parameter. To remove this, you can use:
ALTER USER user@host MAX_CONNECTIONS_PER_HOUR 0;
関連するコンテンツ
- 質問済み 6年前
- 質問済み 6年前
- AWS公式更新しました 3ヶ月前
- AWS公式更新しました 3年前
MAX_CONNECTIONS_PER_HOUR
is a MySQL per-user parameter. To remove this, you can use:
ALTER USER user@host MAX_CONNECTIONS_PER_HOUR 0;
This fixed it. It's weird, the USER table does not have this parameter visible, and the mysql feedback from running the query is '0 rows affected', but it did work.
You can check this with
SELECT User, max_connections, max_user_connections FROM mysql.user;
. The0 rows affected
is normal, this happens with any alters to users. Can you mark this answer correct if it answered your question?