how do you delete a mysql username ek and the database it owns? which is ekstats

drop database_name;

al go to /var/lib/mysql and delete the database directory. (assuming /var/lib/mysql is where your mysqls are stored)

To remove the username:


delete from user where user = 'ek';
delete from db where user = 'ek';


To delete database:


rm -rf /var/lib/mysql/ekstats

I suggest you download phpMyAdmin (http://sourceforge.net/projects/phpmyadmin/) which is the most complete and simple MySQL administration interface.