Hi All,

I am setting up phpMyAdmin as a central page so that multiple users can login to their own databases.

I have got it all working fine, but after a user logs in and then clicks their database on the left nav bar, one of the options at the bottom of the main screen is for them to drop their database.

Does anyone know how to make it so they cant drop\delete their own database using phpMyAdmin?:confused:

thanks in advance,
Matt

Don't quote me (I might be wrong), but I think you actually need to grant the 'drop' privilege to the users when you initially set privileges for the standard hosting user..... I'm sure it's in the MySQL docs somewhere.......

Yes, it all depends on what authority and access you grant the username for the specifica database. If they do not have drop or all access, it can not be dropped. PhpMyAdmin can not simply drop the database when the logged on user does not have that authority.