Vidyalelo
MySQL · Q31

MySQL

Programming · MySQL · question 31

Q31

Which of these grant table scope columns is case insensitive?

A.
Host
B.
User
C.
Password
Answer
D.
Db

Answer: Option C

Solution

Answer: Option C
Solution:
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.