远程连接到 clearDB heroku 数据库

我如何使用例如 MySQL 查询浏览器在 heroku 上远程连接到 ClearDB MySQL 数据库.在哪里获取url、端口、登录名和密码?

How can i perform a remote connect to ClearDB MySQL database on heroku using for example MySQL Query Browser. Where to get url, port, login and password?

推荐答案

在 heroku 网站中,转到我的应用程序并选择您已安装 ClearDB 的应用程序.

In heroku website, go to My Apps and select the app on which you have installed ClearDB.

在顶角点击插件,然后选择ClearDB MySQL 数据库.在那里,单击您的数据库并选择端点信息"选项卡.在那里你会看到你的用户名/密码.可以通过运行获取到数据库的 URLheroku config --app 在命令行中.

On the top corner click on Addons and then select ClearDB MySQL Database. Once there, click on your database and choose the 'Endpoint Information' tab. There you see your username/password. The URL to the database can be acquired by running heroku config --app <YOUR-APP-NAME> in the command line.

就我而言,它类似于:mysql://user:pass@us-cdbr-east.cleardb.com/DATABASE?reconnect=true您需要的是这部分:us-cdbr-east.cleardb.com

In my case, it was something like: mysql://user:pass@us-cdbr-east.cleardb.com/DATABASE?reconnect=true What you need is this part: us-cdbr-east.cleardb.com

相关文章