I'm looking to connect my JAWSDB to my local mysql client. On the JAWSDB docs on Heroku we get this breakdown of the database url:
我想把我的JAWSDB连接到本地mysql客户端。在Heroku上的JAWSDB文档中，我们得到了这个数据库url的分解:
mysql://user:pass@instance:port/default_schema
This is how my database url is formatted. My mysql client (MYSQL Workbench) is asking for a 'host'. What part of the url do I put here? Or where can I find this information?
这就是我的数据库url的格式。我的mysql客户端(mysql Workbench)需要一个“主机”。url的哪一部分呢?或者我在哪里可以找到这些信息?
3 个解决方案
#1
3
Your Host in this case will be "instance". It will be a long string that starts after the "@" symbol and ends before the ":"
在这种情况下，您的主机将是“instance”。它将是一个长字符串，从“@”符号后面开始，在“:”之前结束。
My Host looks somthing like this... enqxqx10c2f7hv2e.cbetxd3yhwsb.us-east-1.rds.amazonaws.com
我的主人看起来像这样……enqxqx10c2f7hv2e.cbetxd3yhwsb.us -东- 1. - rds.amazonaws.com
I pulled it from this connection string... mysql://kjygfmf3pfg4q148:kshfm2g4aflfy2a9@enqxqx10c2f7hv2e.cbetxd3yhwsb.us-east-1.rds.amazonaws.com:3306/xmvmgh118drq2x10
我从这个连接字符串中取出它……mysql:/ / kjygfmf3pfg4q148:kshfm2g4aflfy2a9@enqxqx10c2f7hv2e.cbetxd3yhwsb.us -东- 1. rds.amazonaws.com:3306 / xmvmgh118drq2x10
Hope this helps!
希望这可以帮助!
#2
1
As Tommy pointed out, the instance referenced in the documentation is the hostname of the server. We have updated our docs to be more explicit about this.
正如Tommy指出的，文档中引用的实例是服务器的主机名。我们已经更新了我们的文档以更明确地说明这一点。
#3
0
It turns out 'instance' in the URL is the host.
URL中的“实例”就是主机。
#1
3
Your Host in this case will be "instance". It will be a long string that starts after the "@" symbol and ends before the ":"
在这种情况下，您的主机将是“instance”。它将是一个长字符串，从“@”符号后面开始，在“:”之前结束。
My Host looks somthing like this... enqxqx10c2f7hv2e.cbetxd3yhwsb.us-east-1.rds.amazonaws.com
我的主人看起来像这样……enqxqx10c2f7hv2e.cbetxd3yhwsb.us -东- 1. - rds.amazonaws.com
I pulled it from this connection string... mysql://kjygfmf3pfg4q148:kshfm2g4aflfy2a9@enqxqx10c2f7hv2e.cbetxd3yhwsb.us-east-1.rds.amazonaws.com:3306/xmvmgh118drq2x10
我从这个连接字符串中取出它……mysql:/ / kjygfmf3pfg4q148:kshfm2g4aflfy2a9@enqxqx10c2f7hv2e.cbetxd3yhwsb.us -东- 1. rds.amazonaws.com:3306 / xmvmgh118drq2x10
Hope this helps!
希望这可以帮助!
#2
1
As Tommy pointed out, the instance referenced in the documentation is the hostname of the server. We have updated our docs to be more explicit about this.
正如Tommy指出的，文档中引用的实例是服务器的主机名。我们已经更新了我们的文档以更明确地说明这一点。
#3
0
It turns out 'instance' in the URL is the host.
URL中的“实例”就是主机。