如何在 cpanel 中找到 mysql 服务器名称?我需要它用于续集专业版
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/4127593/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how do I find the mysql server name in cpanel? I need it for sequel pro
提问by Johnny
I'm trying to setup my databases in Sequel Pro(a mysql app). Localhost won't do. Any idea how I can get server name?
我正在尝试在Sequel Pro(一个 mysql 应用程序)中设置我的数据库。本地主机不会做。知道如何获取服务器名称吗?
采纳答案by ceejayoz
You should be able to use the IP address or host name of your server.
您应该能够使用服务器的 IP 地址或主机名。
回答by Lekensteyn
Your MySQL server name is often te same as your website domain (e.g. example.com
).
您的 MySQL 服务器名称通常与您的网站域相同(例如example.com
)。
From http://dev.mysql.com/doc/refman/5.1/en/connection-access.html:
从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
您的身份基于两条信息:
- 您连接的客户端主机
- 您的 MySQL 用户名
So even if you've know your host, you have to allow remote connections with a specified user. Please see this guidefor that. Your IP addresscould be entered as host.
回答by Kyle Hudson
Try your websites domain, also check to see if the mysql server allows remote connections.
尝试您的网站域,同时检查 mysql 服务器是否允许远程连接。