How to grant "select" on more than one table in MySQL?

i want to do something like

grant select on arpg.t_account,arpg.t_char to peeker@'localhost';

but fails, is there a way to 开发者_开发知识库do so?

You can't, you can write a script to manage it for you. There is also some functionality in the MySQL admin tools to let you do it with point and click ease.

Nope. Not in a single statement. You can't even use a wildcard such as arpg.t_% here.