为了实现你所要的功能,
你必须注意你的 MySQL 版本必须是 MySQL 4.0.2 以上的
同时这种功能只能通过 GRANT 语句来实现,GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...]
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER cipher [AND]]
[ISSUER issuer [AND]]
[SUBJECT subject]]
[WITH [GRANT OPTION | MAX_QUERIES_PER_HOUR # |
MAX_UPDATES_PER_HOUR # |
MAX_CONNECTIONS_PER_HOUR #]]
有注意到 MAX_QUERIES_PER_HOUR , MAX_UPDATES_PER_HOUR ,MAX_CONNECTIONS_PER_HOUR 吧,
不过只限制并发可能还是有点困难的
:)更详细地请查看
http://www.mysql.com/doc/en/User_resources.html
你必须注意你的 MySQL 版本必须是 MySQL 4.0.2 以上的
同时这种功能只能通过 GRANT 语句来实现,GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY [PASSWORD] 'password']
[, user_name [IDENTIFIED BY [PASSWORD] 'password'] ...]
[REQUIRE
NONE |
[{SSL| X509}]
[CIPHER cipher [AND]]
[ISSUER issuer [AND]]
[SUBJECT subject]]
[WITH [GRANT OPTION | MAX_QUERIES_PER_HOUR # |
MAX_UPDATES_PER_HOUR # |
MAX_CONNECTIONS_PER_HOUR #]]
有注意到 MAX_QUERIES_PER_HOUR , MAX_UPDATES_PER_HOUR ,MAX_CONNECTIONS_PER_HOUR 吧,
不过只限制并发可能还是有点困难的
:)更详细地请查看
http://www.mysql.com/doc/en/User_resources.html
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货