mysql 权限控制

gistfile1.txt

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'rootpasswd' WITH  MAX_CONNECTIONS_PER_HOUR 5; 
GRANT ALL PRIVILEGES ON *.* TO 'username'@'1.1.0.123' IDENTIFIED BY 'rootpasswd'  MAX_CONNECTIONS_PER_HOUR 5; 
GRANT SELECT ON dbname.* to 'username'@'%' IDENTIFIED BY by 'iamwangnc';
FLUSH PRIVILEGES;

select * from mysql.user;

REVOKE ALL PRIVILEGES ON *.* TO 'root'@'%';
delete from mysql.user where Host='%';
FLUSH PRIVILEGES;

文档：
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#user-names