The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Tie existing MySQL databases to existing users

Discussion in 'General Discussion' started by wholehog, Oct 29, 2007.

  1. wholehog

    wholehog Registered

    Joined:
    Mar 15, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    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!
     
Loading...

Share This Page