Difference between DB host name and DB name?

[Rockefeller]

It says the DBs name is closing1_localhost, so where can I find the DB host name? Is it always localhost?

 

[mulligan]

host name would be something like ... mysql.domain-name.com

 

[tristanperry]

The hostname is the actual name of the server where MySQL is installed. If everything is on the one server (i.e. it's not a 'complicated' cluster), then the hostname is simply "localhost"

So yes, it's *usually* localhost.

If (say) it's a cluster of servers though, then the DB hostname would be the IP address of the server where MySQL is installed on.

 

[south]

The hostname is the actual name of the server where MySQL is installed. If everything is on the one server (i.e. it's not a 'complicated' cluster), then the hostname is simply "localhost"

So yes, it's *usually* localhost.

If (say) it's a cluster of servers though, then the DB hostname would be the IP address of the server where MySQL is installed on.

Correct. It's very unusual to have it as anything else. For security purposes, it is much safer to have the sql server on the same machine (localhost, which is 127.0.0.1) rather than on a public IP address.