> > >

MySQL MCQs

Which of the following is a correct way to show that last queries executed on MySQL?

First execute SET GLOBAL log_output = ‘TABLE’: Than execute SET GLOBAL general_log = ‘ON’: The last queries executed are saved in the table mysql.general_log

Edit the MySQL config file (mysql . com) and add the following line Log = /var/log/mysql/mysql.log

Ececute view . mysql_history

Restart MySQL using the following line tail –f /var/log/mysql . log

Answer

Correct Answer: First execute SET GLOBAL log_output = ‘TABLE’: Than execute SET GLOBAL general_log = ‘ON’: The last queries executed are saved in the table mysql.general_log

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it