如何在 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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 17:40:16  来源:igfitidea点击:

how do I find the mysql server name in cpanel? I need it for sequel pro

mysql

提问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.

因此,即使您知道您的主机,您也必须允许与指定用户的远程连接。请参阅本指南。您的IP 地址可以作为主机输入。

回答by Kyle Hudson

Try your websites domain, also check to see if the mysql server allows remote connections.

尝试您的网站域,同时检查 mysql 服务器是否允许远程连接。