当前位置: 技术问答>linux和unix
请教大虾,关于grant
来源: 互联网 发布时间:2015-07-26
本文导语: 编程远程操作mysql数据库 一、在用mysql_real_query()时,查询语句为grant (权限) on example.* to root@"10.111.75.102" identified by "password",但他提示出错信息为Access denied for user:'root@10.111.75.102' to database 'example'. 二、在用my...
编程远程操作mysql数据库
一、在用mysql_real_query()时,查询语句为grant (权限) on example.* to root@"10.111.75.102" identified by "password",但他提示出错信息为Access denied for user:'root@10.111.75.102' to database 'example'.
二、在用mysql_real_query()时,查询语句为grant (权限) on example.rfile to root@"10.111.75.102" identified by "password",但他提示出错信息grant command denied to user:'root@10.111.75.102' for table 'rfile'.
请教大虾这可能是什么原因?怎么改正?谢谢!
一、在用mysql_real_query()时,查询语句为grant (权限) on example.* to root@"10.111.75.102" identified by "password",但他提示出错信息为Access denied for user:'root@10.111.75.102' to database 'example'.
二、在用mysql_real_query()时,查询语句为grant (权限) on example.rfile to root@"10.111.75.102" identified by "password",但他提示出错信息grant command denied to user:'root@10.111.75.102' for table 'rfile'.
请教大虾这可能是什么原因?怎么改正?谢谢!
|
mysql的mysql数据库,user表,看看是不是没给root@10.111.75.102用户加grant权限。
|
up