1# switching from mysql.global_priv to mysql.user 2set global sql_mode=""; 3set local sql_mode=""; 4alter table mysql.user modify User char(16) binary not null default ''; 5alter table mysql.db modify User char(16) binary not null default ''; 6alter table mysql.tables_priv modify User char(16) binary not null default ''; 7alter table mysql.columns_priv modify User char(16) binary not null default ''; 8alter table mysql.procs_priv modify User char(16) binary not null default ''; 9alter table mysql.proc modify definer char(77) collate utf8_bin not null default ''; 10alter table mysql.event modify definer char(77) collate utf8_bin not null default ''; 11flush privileges; 12select user(); 13Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr 14def user() 253 77 14 N 1 39 8 15user() 16root@localhost 17create user a17aaaaaaaaaaaaa0@localhost; 18ERROR HY000: String 'a17aaaaaaaaaaaaa0' is too long for user name (should be no longer than 16) 19grant usage on *.* to a17aaaaaaaaaaaaa0@lodalhost; 20ERROR HY000: String 'a17aaaaaaaaaaaaa0' is too long for user name (should be no longer than 16) 21drop user a17aaaaaaaaaaaaa0@lodalhost; 22ERROR HY000: String 'a17aaaaaaaaaaaaa0' is too long for user name (should be no longer than 16) 23alter table mysql.user modify User char(80) binary not null default ''; 24alter table mysql.db modify User char(80) binary not null default ''; 25alter table mysql.tables_priv modify User char(80) binary not null default ''; 26alter table mysql.columns_priv modify User char(80) binary not null default ''; 27alter table mysql.procs_priv modify User char(80) binary not null default ''; 28alter table mysql.proc modify definer char(141) collate utf8_bin not null default ''; 29alter table mysql.event modify definer char(141) collate utf8_bin not null default ''; 30flush privileges; 31select user(); 32Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr 33def user() 253 141 14 N 1 39 8 34user() 35root@localhost 36set global sql_mode=default; 37# switching back from mysql.user to mysql.global_priv 38