db name is too long

[dai198920032000]

Please help me, i'm using version

Server Version

1.62.5

When I click create database, I get the error message db name is to loong
I tried 1 character but got the same error

 

[Richard G]

Odd... seems a bug to me. Normally it's 16 characters by default.

 

[MaXi32]

I don't have this issue on mariadb and directadmin version 1.62.6. I tried both max_username_length=14 and max_username_length=30 in directadmin.conf

I had this issue before this might be related: https://forum.directadmin.com/threads/da-1-61-1-db-name-is-too-long-mysql-length-checking-bug.61475/ and check post by @bdacus01 there, it is very useful for different version of sql.

The solution from my case that I had before was to rebuild mariadb from custombuild. I remember that, everytime I have finished install directadmin from scratch, I need to rebuild whether mariadb or mysql at least one time to fix some errors in sql. The initial installation seems does not work well.

 

[Richard G]

The initial installation seems does not work well.

I never had those issues on my servers, not with Mysql and not with MariaDB.

 

[raghav]

I had this issue. Restarting mariadb fixed it. Try your luck friend.