MYSQL Help Please


#1

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


#2

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


#3

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.


#4

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.


#5

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

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

Maximum Cash Discount on any plan with MAXCASH

How To Install PHP.INI / ionCube on DreamHost


#6

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.