我刚刚创建了一个JawsDB MySQL实例,并将其与我的应用程序配对。执行heroku config: get JAWSDB_URL
命令会返回以下字符串:
mysql://(redacted-username):(redacted-password)@h40lg7qyub2umdvb.cbetxkdyhwsb.us-east-1.rds.amazonaws.com:3306/schema
当尝试使用任何数据库管理器GUI(例如MySQL Workbench或HeidiSQL)使用以下参数连接到此数据库时:
| Key | Value |
| ---------- | ------------------- |
| hostname | h40lg7qyub2umdvb.cbetxkdyhwsb.us-east-1.rds.amazonaws.com |
| port | 3306 |
| username | (redacted-username) |
| password | (redacted-password) |
| connection | TCP/IP |
我收到以下错误信息:
Failed to Connect to MySQL at h40lg7qyub2umdvb.cbetxkdyhwsb.us-east-1.rds.amazonaws.com:3306 with user (redacted-username)
Lost connection to MySQL server at 'reading initial communication packet', system error: 0
这是我第二次尝试 - 我刚刚设置的JawsDB实例出现了相同的错误,所以我将其删除,但在这里仍然遇到了相同的错误。有什么想法吗?