What are some good ideas regarding user security

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What are some good ideas regarding user security in MySQL?

There is no user without a password. There is no user without a user name. There is no user whose Host column contains % (which here indicates that the user can log in from anywhere in the network or the Internet). There are as few users as possible (in the ideal case only root) who have unrestricted access.

(Continued on next question...)

Other Job Interview Questions

• How do you control the max size of a HEAP table?
• If the value in the column is repeatable, how do you find out the unique values?
• How to connecting to the MySQL Server
• MySQL - Disk Issues
• MySQL - Setting Up Passwords
• General Information About MySQL
• What do % and _ mean inside LIKE statement?
• How MySQL Opens and Closes Tables
• How to get Maximum Performance from MySQL
• Explain TIMESTAMP DEFAULT ‘2006:09:02 17:38:44? ON UPDATE CURRENT_TIMESTAMP.
• More...