mysql添加账号,设置权限,修改密码命令

作者:笨小孩 发布于:2013-9-13 17: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( '********' ) ;

标签: MySQL

发表评论:

手机版 | 
Copyright © 2012 lamp46.com All Right Reserved. sitemap