远程MySQL IP访问

问题描述：

我希望授予权限，不同的用户使用以.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.