Tie existing MySQL databases to existing users

wholehog

Registered
Mar 15, 2007
1
0
151
I've dug around in the /scripts directory to no avail. The problem I'm having right now is that a customer of mine has several databases in this format:

customers_database1
customers_database2
customers_database3

Note the "s" at the end of "customers".

I manually migrated these over to the server (he didn't have CPanel on the old one). However, due to Cpanel's 8 character username limit, I can only create "customer" instead of "customers" as his username. The end result is databases like this:

customers_database1

And Cpanel looking for the singular version of the naming procedure:

customer_database1

This results in the databases not showing up in his phpMyAdmin list, being backed up, etc.

Short of renaming all of the databases and changing all of the connection strings, is there anyway I can just tell Cpanel that those are his databases? I'm almost positive the answer is "No" but I'm tossing it out there to those of you whom probably have a lot more experience with Cpanel than I do.

Thanks!