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.

Silly MYSQL NAMES

Discussion in 'General Discussion' started by scubakevin, Oct 26, 2003.

  1. scubakevin

    scubakevin Registered

    Joined:
    Oct 25, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Cancun
    Can someone help me to understand why in gods name does the CPANEL add the username_ to all of my databases and database users names???

    I am trying to migrate a shitload of heavy DB's and Sites that are all database driven and I have never seen anything where when I create a DB name the stupid system adds a prefix to it preventing me from using existing config files for all of the sites that I am migrating.

    I installed phpMyAdmin as a standalone in one of the sites to test and used the root user and pass for MySql and it allowed me to do everything except.........Actually use the databases and usernames created. I could not even see them in the cpanel for that site using phpmyadmin.

    Anybody got any ideas to get around this or is it better to just get rid of cpanel and go back to controlling server from ssh?

    Between the issues of the open ssl, mysql database, and some other stupid stuff I am really disappointed in the $1500 investment plus having a tech install it.

    Some of the features are nice but I feel like I lost alot.

    Hanna
     
  2. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Atlanta, GA
    For one, to guarantee uniqueness without receiving errors saying the database already exists.

    For two, since mysql owns the DBs, there must be an easy way to identify who owns the databases for multiple different needs in the system (quotas, account backups, copying accounts, etc.).
     
  3. scubakevin

    scubakevin Registered

    Joined:
    Oct 25, 2003
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Cancun
    NO WAY AROUND IT

    So you are saying that there is no manner to get around this?

    Thats not a good feature.
     
  4. SarcNBit

    SarcNBit Well-Known Member

    Joined:
    Oct 14, 2003
    Messages:
    1,010
    Likes Received:
    3
    Trophy Points:
    38
    You could always bypass CPanel and manually create your DBs
     
Loading...

Share This Page