Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2005
    South West US

    Question New to cPanel - MySQL question

    Hi all,
    I just perchased a dedicated server to move my site(s) from a VPS to DS. The server I bought uses cPane. I was able to get it all configured (with help from PSM) and now have one web site hosted there as a test.

    When I go into cPanel as the user for this web site and try to make a test database with MySQL, it creates a database with a name that tags on the user name. FOr example, say the user name for this account is User1 and the test database I try to creat is called testdb. Well, when I click the create button, the database that actually gets created is User1_testdb Is there something in the configurration settings in cPanel that I can set so that it will just create a database with the exact name I specify and not tag on the user name in front?


  2. #2
    Join Date
    Mar 2005
    Brighton, MI
    you can go in manually and change the database name via ssh. If you do that however you will lose phpmyadmin access via the cpanel as the username prefix ties it to that particular account

  3. #3

    Why is that such a big deal?
    If you get more clients on your server it's better to keep it that way
    Caro.Net: Support is everything
    Offering High Quality Dedicated Servers.

  4. #4
    Join Date
    Feb 2006
    Manila, Philippines
    This is the default naming convention for MySQL on cPanel so it can trace easily the ownership of a database.

    You can just adjust the database names in the scripts you are using and you should be fine.
    Don't Lose Your Website Ever Again!
    Backup All Your Domains and MySQL Databases Automatically
    Grab this Website Backup Software today.

  5. #5

    That's the default settings of Cpanel. Also check the settings in the cpanel of that domain if you find the settings to remove the prefix.

    Thank you.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts