用以下的方法增加MysQL的用户
,并授予外部访问的权限//在root的状态下,运用下面语句,分为二种情况,一种是mysql初始化没有口令的时候,二是有口令的时候
1、mysql --user=root mysql
2、mysql --user=root mysql -p
//进行mysql的提示符后,输入以下二条命令,一是建立用户,二是刷新权限,立即生效;(连结的用户名为kuke,密码为kuke.info)
//建立二个用户,一个用于操作比如数据库连结及报表连结,一个用于以后远程统一管理。
GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY 'kuke.info' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'kuke' IDENTIFIED BY 'kuke.info' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'ctnweb' IDENTIFIED BY 'ctn' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'kuke' IDENTIFIED BY 'kuke.info' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'ctnweb' IDENTIFIED BY 'ctn' WITH GRANT OPTION;
FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *. TO 'ctnweb' IDENTIFIED BY 'ctn' WITH GRANT OPTION;
FLUSH PRIVILEGES;
上海酷克信息科技有限公司 Kuke Infomation Tec. Co.,LTD
公司地址:上海浦东新区向城路28号爵士大厦A座9C
座机:131 6619 7577 传真:021 5831 4494
Email:sutra@kuke.info 网址: http://www.kuke.info/