I am trying to set up my databases in Sequel Pro (mysql application). Localhost will not do. Any idea how I can get the server name?
You should be able to use the IP address or host name of your server.
Your MySQL server name often matches your domain of your site (for example, example.com).
example.com
From http://dev.mysql.com/doc/refman/5.1/en/connection-access.html :
Your identity is based on two pieces of information:The client host you are connecting fromMySQL username
, , . . . IP- .
Try the domain of your sites, and also check if the mysql server allows remote connections.