远程MySQL IP访问 [英] Remote Mysql IP access

问题描述

我希望授予权限，不同的用户使用以.php脚本我的数据库

I wish to grant permissions to various users for my databases using a .php script

但似乎在通过PHPMYADMIN访问，或在GRANT命令被拒绝PHP文件

But it seems that GRANT command is denied when accessed via PHPMYADMIN or a .php file

有没有出路才达到这一点？

Is there a way out to achive this?

推荐答案

您必须有某种权利这样做，这是你如何检查它们：

You have to have some kind of rights to do that, This is how you can check them:

show grants for 'youruser'@'localhost';

如果你不能找到像什么WITH GRANT OPTION 很可能，你不能做到这一点。这不是PHP的限制。

If you cannot find anything like WITH GRANT OPTION it is very likely that you cannot do that. It's not a limitation of PHP.

更多关于 GRANT 命令：的 http://dev.mysql.com/doc/refman/5.1/en/grant.html

这篇关于远程MySQL IP访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！