开发者

PHP script to check for alter mysql database

I am trying to install a Photo App (ZenPhoto) on my webserver and the installer complains:

Warning!
Your Database user must have Alter, Create, Dele开发者_JAVA技巧te, 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?


GRANT INDEX, ALTER ON `server`.`database` TO `username`@`username_server`;

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜