Is it possible to have multiple MySQL databases running on the same “host”? So for example I have mysql.kelvinluck.com set up with a database on it. I would like to host another database on this same host (for cleanliness more than anything else). Ideally I would also like to be able to create a user with access to both databases (like an admin user) and a seperate user for each database…
Is this possible or do I have to set up a different “DB Hostname” for each database?