MYSQL Help Please

Hi All,

Just setting up a new DB for my domain name. I currently have one database setup and it uses the host of mysql.mydomain.com

So when i went to setup a new database on my domain through the panel, i was asked for the database name, hostname, new user/password to create it.

What i am wanting to do is just create a new database with a new username/password to access it. Am i able to use the current mysql.mydomain.com as a hostname or do i need a new hostname for this new database?

If i can use the current hostname (mysql.mydomain.com) how can i create the database without a new hostname for it? it says i can't re-use the mysql.mydomain.com as its already in use. So i am not able to create the new database.

Any help would be muchly appreciated.

cheers

Existing hostnames can be used.

Theres a section above new hostname that says use hostname, just set that to the existing hostname and you'll have no problem

Hi There,

Thanks for your reply. Unfortunately I don't have the option to select an existing hostname. It seems that i can only add a new one. Please see the below pic.

PIC: http://www.churchi.com/images/DH_MYSQL_Error-01.PNG

Any other suggestions?

Thanks.

I do however have this notice at the top saying:
Merge all databases and hostnames on zero:roxanna to swordfish:quilliams

Maybe i need to merge all databases to the same server, to enable the option to use the same hostname? would this make sense?

Thanks.

That very well may be the case. Here's what the standard setup looks like:

http://i25.tinypic.com/20l02vr.png




How To Install PHP.INI / ionCube on DreamHost

Cheers, thanks for that.

I have confirmed that i need to merge all databases to the one server before i can use the same hostname for multiple databases.

Thanks for your help.