πŸ“Š MySQL
Q. Which of these grant table scope columns is case insensitive?
  • (A) Host
  • (B) User
  • (C) Password
  • (D) Db
πŸ’¬ Discuss
βœ… Correct Answer: (C) Password

Explanation: In MySQL, the "Password" column in the grant tables, such as "mysql.user" table, is case insensitive. This means that when you grant or revoke privileges, the password is matched without considering the case sensitivity. This is particularly important for security reasons, ensuring that users can authenticate regardless of the case of their password input. Hence, Option C is correct.

Explanation by: Neelam Mittal
In MySQL, the "Password" column in the grant tables, such as "mysql.user" table, is case insensitive. This means that when you grant or revoke privileges, the password is matched without considering the case sensitivity. This is particularly important for security reasons, ensuring that users can authenticate regardless of the case of their password input. Hence, Option C is correct.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
105
Total Visits
πŸ“½οΈ
1 y ago
Published
πŸŽ–οΈ
Neelam Mittal
Publisher
πŸ“ˆ
95%
Success Rate