How to increase the limit for the length of database username in MariaDB?

Created:

2017-06-09 12:01:43 UTC

Modified:

2017-08-16 14:11:57 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to increase the limit for the length of database username in MariaDB?

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk Onyx for Linux

Question

How to increase the limit for the length of database username in MariaDB?

Answer

Run the following queries in MariaDB console:

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 '';
alter table mysql.proxies_priv modify User char(80) COLLATE utf8_bin not null default '';
alter table mysql.proxies_priv modify Proxied_user char(80) COLLATE utf8_bin not null default '';
alter table mysql.proxies_priv modify Grantor char(141) COLLATE utf8_bin not null default '';
alter table mysql.servers modify Username char(80) not null default '';
alter table mysql.procs_priv modify Grantor char(141) COLLATE utf8_bin not null default '';
alter table mysql.tables_priv modify Grantor char(141) COLLATE utf8_bin not null default '';
flush privileges;
Have more questions? Submit a request
Please sign in to leave a comment.