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.
cPanel.net Support Ticket Number: