how do I find the mysql server name in cpanel? I need it for sequel pro
I'm trying to setup my da开发者_JAVA百科tabases in Sequel Pro (a mysql app). Localhost won't do. Any idea how I can get server name?
You should be able to use the IP address or host name of your server.
Your MySQL server name is often te same as your website domain (e.g. 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 from which you connect
- Your MySQL user name
So even if you've know your host, you have to allow remote connections with a specified user. Please see this guide for that. Your IP address could be entered as host.
Try your websites domain, also check to see if the mysql server allows remote connections.
精彩评论