12.2 Grant Table Scope Column Properties

Scope columns in the grant tables contain strings. The default value for each is the empty string. The following table shows the number of characters permitted in each column.

Table 12.1 Grant Table Scope Column Lengths

Column Name	Maximum Permitted Characters
Host, Proxied_host	255 (60 prior to MySQL 8.0.17)
User, Proxied_user	32
Db	64
Table_name	64
Column_name	64
Routine_name	64

Host and Proxied_host values are converted to lowercase before being stored in the grant tables.

For access-checking purposes, comparisons of User, Proxied_user, authentication_string, Db, and Table_name values are case-sensitive. Comparisons of Host, Proxied_host, Column_name, and Routine_name values are not case-sensitive.