MySQL Restrictions and Limitations / Limits in MySQL / 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 andProxied_host values are converted to lowercase before being stored in the grant tables.
For access-checking purposes, comparisons ofUser,Proxied_user,authentication_string,Db, andTable_name values are case-sensitive. Comparisons ofHost,Proxied_host,Column_name, andRoutine_name values are not case-sensitive.