-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.5.32
-
Component/s: None
-
Labels:None
create user 'a123456789-123456789-123456789-123456789-123456789-123456789-123456789-123456789'@'localhost';
|
connect con1,localhost,a123456789-123456789-123456789-123456789-123456789-123456789-123456789-123456789,,;
|
create database db;
|
ERROR 42000: Access denied for user 'a123456789-123456789-123456789-123456789-1234567'@'localhost' to database 'db'
|
Test case:
--enable_connect_log
|
|
alter table mysql.user modify User char(80) binary not null default ''; |
alter table mysql.db modify User char(80) binary not null default ''; |
alter table mysql.tables_priv modify User char(80) binary not null default ''; |
alter table mysql.columns_priv modify User char(80) binary not null default ''; |
alter table mysql.procs_priv modify User char(80) binary not null default ''; |
alter table mysql.proc modify definer char(141) collate utf8_bin not null default ''; |
alter table mysql.event modify definer char(141) collate utf8_bin not null default ''; |
flush privileges; |
|
create user 'a123456789-123456789-123456789-123456789-123456789-123456789-123456789-123456789'@'localhost'; |
|
--connect (con1,localhost,a123456789-123456789-123456789-123456789-123456789-123456789-123456789-123456789,,)
|
--error ER_DBACCESS_DENIED_ERROR
|
create database db; |
--disconnect con1
|
|
--connection default
|
|
drop user 'a123456789-123456789-123456789-123456789-123456789-123456789-123456789-123456789'@'localhost'; |
|
alter table mysql.user modify User char(16) binary not null default ''; |
alter table mysql.db modify User char(16) binary not null default ''; |
alter table mysql.tables_priv modify User char(16) binary not null default ''; |
alter table mysql.columns_priv modify User char(16) binary not null default ''; |
alter table mysql.procs_priv modify User char(16) binary not null default ''; |
alter table mysql.proc modify definer char(77) collate utf8_bin not null default ''; |
alter table mysql.event modify definer char(77) collate utf8_bin not null default ''; |
flush privileges; |
bzr version-info
revision-id: wlad@montyprogram.com-20130509212557-5cdelkdvf7t61062
|
revno: 3756
|
branch-nick: 5.5
|
- relates to
-
MDEV-4332 Increase username length from 16 characters
-
- Closed
-