Q&A

Q1:How do I completely remove a user? The REVOKE command just eliminates the privileges.
A1: 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.
Q2:What if I tell my Internet service provider to stop running MySQL as root, and it won't?
A2: 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, that don't run important processes as the root user!

Get Sams Teach Yourself PHP, MySQL® and Apache All in One now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.