See the section "The MySQL Command-Line Client" for additional command-line options.
Later, if you need to revoke privileges from foobar, you can use the revoke statement. For example, the following statement revokes all privileges from the user foobar:
REVOKE ALL ON animals FROM foobar;
Advanced database administration, privileges, and security are very complex topics that are beyond the scope of this book. See the section "Reference" at the end of this chapter for links to online documentation. You can also check out Luke Welling's and Laura Thompson's book PHP and MySQL Development from Sams Publishing.
Was this article helpful?