Database name length too long?

Thunderchild

Well-Known Member
Jan 28, 2018
86
3
8
UK
cPanel Access Level
Root Administrator
So I have migrated from one cPanel server to another, all accounts went fine baring one. The database name is too long for MariaDB (and it was on MariaDB already but never mind!). So this is for wordpress.

I can allegedly change the database name length and tell WP the new name. Do i need to do this before or after the move?
 

Thunderchild

Well-Known Member
Jan 28, 2018
86
3
8
UK
cPanel Access Level
Root Administrator
Well i did it in the new server and it is working fine now. It was the database user that was too long. what I do not understand was that this was created under MariaDB in the old server so why did the new server running the same database system not like it. The user was simply not imported so i set up a new one and edited the WP config file and all is working again.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,297
1,251
313
Houston
Hi @Thunderchild

I'm glad to see you got the issue resolved per MariaDB's documentation as of MariaDB 5.5 usernames can be 80 characters long CREATE USER but it hasn't changed as far as I'm aware since then. What version of MariaDB is running on both servers?
 

Thunderchild

Well-Known Member
Jan 28, 2018
86
3
8
UK
cPanel Access Level
Root Administrator
No idea, the old server is now in the VPS afterlife, how do I find it on the new server. I was using LCN.com and I strongly suspect that they are using an old image to setup every new server that is badly out of date. Set up 9 months ago it did still ran SQL and php 5.6.........
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,297
1,251
313
Houston
Hi @Thunderchild


I do the same on both mysql and mariadb servers:

Code:
mysql --version
mysql  Ver 15.1 Distrib 10.2.19-MariaDB, for Linux (x86_64) using readline 5.1
It could very well be possible it's an old image, you might be right there, curious to see what the output is! :)