Set - 2

Question 11 :

What's the default port for MySQL Server?

Answer :

3306


Question 12 :

What does tee command do in MySQL?

Answer :

tee followed by a filename turns on MySQL logging to a specified file. It can be stopped by command note.


Question 13 :

Can you save your connection settings to a conf file?

Answer :

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.


Question 14 :

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

Answer :

mysqladmin -u root -p password "newpassword"


Question 15 :

Use mysqldump to create a copy of the database?

Answer :

mysqldump -h mysqlhost -u username -p mydatabasename > dbdump.sql