Database name length too long?

[Thunderchild]

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?

 

[GOT]

I would change the name before the move.

 

[Thunderchild]

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]

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]

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]

Hi @Thunderchild


I do the same on both mysql and mariadb servers:

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!