mariadb db username length increase

Login to mariadb
use mysql;
ALTER TABLE mysql.user MODIFY  `User` varchar(30) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT ”;
SHOW COLUMNS FROM mysql.user;

Leave a Comment

Your email address will not be published. Required fields are marked *

Open chat