PHP 脚本检查更改 mysql 数据库
我正在尝试在我的网络服务器上安装照片应用程序 (ZenPhoto)，安装程序抱怨：
Warning!
Your Database user must have Alter, Create, Delete, Drop, Index, Insert, Select and Update rights.
Grants found:
GRANT USAGE ON *.* TO 'xxx'@'%' IDENTIFIED BY PASSWORD 'xxx'
我的主机控制面板仅向我显示以下数据库用户权限：
Select Update Create Insert Delete Drop
那么 INDEX 和 ALTER 丢失了吗？ 我可以完成安装，但想知道是否会出现任何问题？ 是否有 PHP / mySQL 函数可以用来检查我是否可以更改数据库？
I am trying to install a Photo App (ZenPhoto) on my webserver and the installer complains:
Warning!
Your Database user must have Alter, Create, Delete, Drop, Index, Insert, Select and Update rights.
Grants found:
GRANT USAGE ON *.* TO 'xxx'@'%' IDENTIFIED BY PASSWORD 'xxx'
My hosts control panel displays me only following database user permissions:
Select Update Create Insert Delete Drop
So INDEX and ALTER are missing?
I could complete the install but would like to know if I should expect any problems?
Is there a PHP / mySQL function that I can use to check if I can ALTER the db?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
但我的猜测是你没有这些权利。最好的办法就是联系你的主机并要求你的用户获得这些权利。
But my guess is you do not have those rights.. Best thing to do is then just contact your host and ask for those rights on your user.