Yes. Let’s take a look at the MySQL Databases page in the DreamHost Web Panel.
There is a particular server running the MySQL software. So first we have a server identifier:
“server name” MySQL Server
Next we have a list of hostnames that DNS resolves to the IP address of the mysql server.
"Hostnames for this MySQL server:
- Add New Hostname
Hostname (these are all interchangeable)"
Then we have a list of databases on this MySQL server:
“Database(s) on this server:
The database is hosted on the server, and the hostname points to the server. So you can have more than one hostname point to the same server, and thus no matter which hostname you choose you can access the database.
So what you want to do is determine the MySQL server the database is on, then choose a hostname that you are keeping for that server, and then configure the scripts on the web sites to use that hostname and the user that is given access to the database.
Customer since 2000 openvein.org