loyeyoung

>check privelages before installing
>it’s not that easy

“SHOW GRANTS FOR CURRENT_USER();”

>other issues can arise during the creation of DB tables

Print MySQL’s error message that table could not be created.

Error: 1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB)
Message: Can't create database '%s' (errno: %d)


“The Right Thing(tm) would be to fix every plugin’s install script to check for the appropriate privileges before, verify the table’s creation after, and prompt the site administrator what to do if the plugin cannot be installed.”

@clorange
The only workaround of which I’m aware is to change the database user’s privileges and add the CREATE right. In my particular case, I used my hosting company’s cPanel interface, but the same result can be had via the command line or phpMyAdmin.

The Right Thing(tm) would be to fix every plugin’s install script to check for the appropriate privileges before, verify the table’s creation after, and prompt the site administrator what to do if the plugin cannot be installed.