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.
Discusssion
Login to discuss.