Question

The grant table scope columns that is case insensitive is _____________

(a) Host

(b) User

(c) Password

(d) Db

The question was posed to me during an internship interview.

Enquiry is from Setting Up Secure Connections in section Access Control and Security of MySQL

Answer 1

The correct option is (a) Host

To explain: ‘Db’ and ‘Table_name’ values are always treated as case sensitive even though treatment of database and table names in SQL statements depends on the filesystem case sensitivity of the host.