How do I completely remove a user? TheREVOKEcommand just eliminates the privileges.
A
To completely remove a user from the privilege table, you have to issue a specific DELETE command from the user table in the mysql database.
Q
What if I tell my Internet service provider to stop running MySQL asroot, and it won't?
A
Switch providers. If your Internet service provider doesn't recognize the risks of running something as important as your database as the root user, and doesn't listen to your request, find another provider. There are providers, with plans as low as $9.95/month (or even free!) that don't run important processes as the root user.