Can you save your connection settings to a conf

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

(Continued from previous question...)

Can you save your connection settings to a conf file?

Yes, and name it ~/.my.conf. You might want to change the permissions on the file to 600, so that it’s not readable by others.

(Continued on next question...)

Other Job Interview Questions

• MySQL Command Interpreter
• What’s the difference between CHAR_LENGTH and LENGTH?
• MySQL - Setting Up Passwords
• MySQL - Reasons NOT to Use Foreign Keys constraints
• MySQL - Tuning Server Parameters
• MySQL - General Security
• What are ENUMs used for in MySQL?
• How do you offload the time/date handling to MySQL?
• MySQL - Speed of INSERT Queries
• Replication in MySQL
• More...