Users deleting their own databases via MySQL Administrator

[GITK Services]

One of our users just deleted his database using the MySQL Administrator remotely. The control panel was obviously out of sync afterwards, and it wouldn't let him create another, but showed no databases there. Is there any way I can stop this happening in future?

Cheers!
Richard.

 

[jmstacey]

If MySQL Administrator is connecting through their user level accounts, I don't think they should be able to do this.
I think DirectAdmin sets permissions as such that users can't create or delete databases.

(Or is that part of phpMyAdmin's own programming?)

I haven't tried MySQL Administrator, but at least in phpMyAdmin, users can not create or delete databases on my servers.

 

[nobaloney]

I'm presuming you mean the MySQL desktop product users can download?

Or is there some other product called MySQL Administrator?

Yes, users can use it to delete databases; it's designed to let users completely manage remote databases.

And no, DA cannot know about it. Perhaps something can be set up in DA to run a script to reconfigure DA when it founds a database in it's own data, but no actual database on the server.

Before asking this as a feature, I'd like some input so I know if I'm understanding this right.

So please respond.

Thanks.

Jeff

 

[GITK Services]

Correct, MySQL Administrator is the free download from mysql.com. The user killed his own DB, but as DA thought he still had an existing one (which he couldn't remove), he couldn't create a new one (as he was at his limit.)