mysql 帐号权限管理

show grants for webdev@'%';

insert into user(Host,User,Password) values('%','user001',password('asd5f4a5fds'));

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `dbname`.* TO 'user001'@'218.17.61.80' identified by 'pwd';

flush privileges;  

存储过程权限

alter routine,create routine

 

参考 http://blog.csdn.net/bonlog/article/details/7706601　　

http://www.adki.me/mysql-identified-how-to-use.html

# 存储过程定义者
select name,definer from proc where db='xxx';