mysql添加账号，设置权限，修改密码命令
2013-9-13 一抹阳光 数据库
CREATE USER 'root'@'%' IDENTIFIED BY PASSWORD '*FCD12DEBA1FE75F12B913B1824DC97C9750B7F8A';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY PASSWORD '*FCD12DEBA1FE75F12B913B1824DC97C9750B7F8A' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
SET PASSWORD FOR 'root'@'%' = PASSWORD( '********' ) ;