Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL DB names and users

Discussion in 'General Discussion' started by MonkeyPants, Jul 10, 2003.

  1. MonkeyPants

    MonkeyPants Member

    Jun 27, 2003
    Likes Received:
    Trophy Points:
    Is there a way to stop cPanel from creating MySQL databases and users with names that go:


    Say for example I copy an existing site from another server not using cPanel which uses only dbname or username .

    Once the copy is complete, my database has been named siteadminname_dbname.

    Here's a specific example. I have a client with a rather poorly done PHP site in terms of database access and authentication. Of the several hundred files for the site, perhaps 1/3 have lines specifying the username, password, and database name for the database.
    So before on the other server the db access username was green and the admin username was green and the database was named:


    Now that it's transferred over to the cPanel server the db username is:


    the admin user is still green
    and the database is called:


    This messed things up significantly. Rather than changing all of the PHP files I recreated the original usernames and database names on the new server to get everything working correctly again.

    Is there a way to prevent this? I am beginning to think the cPanel installation on our server is messed up.

    MonkeyPants. :D Support Ticket Number:
  2. Aerosmith

    Aerosmith Well-Known Member

    Feb 17, 2002
    Likes Received:
    Trophy Points:
    From my understanding thats the way it is designed to work. If the DBs were not named to the accounts then the first person to name a DB "main" would lock out that name for anyone else to use. Also w/o the names the way it is it would be hard to regulate which accounts had rights to what DBs. Support Ticket Number:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice