PDA

View Full Version : Preventing database creation from phpMyAdmin



hendrix74
10-28-2006, 11:22 AM
Hi,

I noticed that any user created through DA can create a database from phpMyAdmin. How can I prevent this?

Don't get me wrong, I still want to allow them to create databases through DA as it will set a database name using "useraccount_database" but if they create a database from phpMyAdmin they can set whatever name they want and their database is also visible and editable by every other user.

Thank you!

pucky
10-28-2006, 12:00 PM
Ye, i'd like to know too. I mean users should not be allowed to create db via phpmyadmin. Then what is the purpose of providing a limit on the number of dbs a user can create via DA if they can log into phpmyadmin and create dbs?

chatwizrd
10-28-2006, 04:57 PM
Users cant create databases on my phpmyadmin install. Why can they on yours? Maybe your permissions are not right?

# Create new database:
No Privileges

hendrix74
10-29-2006, 06:45 AM
where do we set that?

smtalk
03-26-2007, 01:07 PM
You don't need to set it :) Users have no privileges to create databases via phpMyAdmin.

floyd
03-26-2007, 04:46 PM
hendrix74,

Have you actually used phpmyadmin to create a database as a regular user or did you just see the link to create a database?