delete mysql test db

[Tim]

With wich user i can delete the test database in mysql?

 

[Icheb]

Think you need the da_admin or root user, but is it recommended ?

I currently have problems with a user from a reseller who fills up the test db every time. How do i block access or kill the db entirely without harming the system ?

 

[Tim]

that's why i want to delete the DB same problem here
i tried:

root user
my own user
admin user of da

nothing ..

 

[DirectAdmin Support]

Hello,

the root mysql user or da_admin user should be able to toast the test database. (It's not needed for anything).

cat /usr/local/directadmin/conf/mysql.conf
(get login/pass)
mysql -uda_admin -ppass
DROP DATABASE test
quit

John

 

[Tim]

nice! thanks John.

I could figure it out by myself

 

[Driesp]

Sorry for bumping this old thread.

I've users who are creating test_% databases on the server,
they are visible to all users on the server.

I don't know how they managed to create a database with the name test_...
because all users don't have create database privileges.
The weird thing is that they did create a test database, and I don't know how.

How to prevent this?
Why is the test database and these privileges not revoked by directadmin's installer? Shouldn't it be?

Thanks