How do you change a password for an existing use

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

(Continued from previous question...)

How do you change a password for an existing user via mysqladmin?

mysqladmin -u root -p password "newpassword"

(Continued on next question...)

Other Job Interview Questions

• What is the difference between mysql_fetch_array and mysql_fetch_object?
• Functionality Missing from MySQL - Transactions
• MySQL - Table Locking Issues
• MySQL - How can I use replication to improve performance of my system?
• When would you use ORDER BY in DELETE statement?
• Explain federated tables.
• How would you change a column from VARCHAR(10) to VARCHAR(50)?
• How do you change a password for an existing user via mysqladmin?
• MySQL - Table Locking Issues
• What does tee command do in MySQL?
• More...