Preventing database creation from phpMyAdmin

[hendrix74]

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]

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]

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]

where do we set that?

 

[smtalk]

You don't need to set it Users have no privileges to create databases via phpMyAdmin.

 

[floyd]

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?