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.