未捕获的异常'PDOException with message'SQLSTATE [HY000] [2013]

I am trying to get my mysql db up and running on amazon rds however I am running into an issue. When trying to connect to my db via php from a remote server to pull information I am getting the following error.

Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 110'

And it points to the line that shows my dbhostname username password etc. What can I do to get past this error. The hostname etc seems to be fine as I can connect to the db using mysql workbench using the same credentials. What am I missing?

Note PDO and Mysql is installed on the remote php server

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
duane2364 2015-11-12 00:06
关注
Found out that this was an issue with the inbound of Firewall rules on my AWS RDS server. What made me think it was a firewall error is that the error referred to packets and losing connections. Also that the same code was working before and the PDO extensions not installed on PHP gave an entirely different error.

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

未捕获的异常'PDOException with message'SQLSTATE [HY000] [2013] mysql php
2015-11-07 10:47

回答 1 已采纳 Found out that this was an issue with the inbound of Firewall rules on my AWS RDS server. What mad
致命错误：未捕获PDOException：SQLSTATE [HY093]：参数号无效：混合命名和位置参数 php postgresql
2019-07-31 16:30

回答 1 已采纳 you can't use :param and ? use :id instead of ? but for update you could use 'UPDATE '
未捕获的PDOException：SQLSTATE [HY093]：参数号无效：参数未定义[重复] mysql php
2018-07-05 08:34

回答 1 已采纳 There are some syntax errors. Like no space after SET and before WHERE keyword. I have added and u
php 7 pdoexception,关于php：未捕获的异常’PDOException’
2021-03-17 11:39

爱吃番茄great的博客这是我得到的错误 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'tguzer'@'localhost' (using password: YES)' in /home/tggamin1/public_...
未捕获的异常PDOException：完整性约束违规错误 php sql
2019-04-12 18:35

回答 1 已采纳 A foreign key constraint requires a record in the foreign table for INSERT. A record cannot be de
带有消息'SQLSTATE [HY093]的未捕获异常'PDOException'：参数号无效' mysql php
2016-05-11 21:12

回答 1 已采纳 I think this might be because you have decared each binding twice in the statement e.g. :firstname
致命错误：未捕获PDOException：SQLSTATE [42000] php
2017-02-15 11:38

回答 1 已采纳 Try adding quotes around id=$search $where=' AND (cognome like "%'.$search.'%" OR nome like "%'.$
mysql_unbuffered_query pdo,PDO“未捕获异常”PDOException'..其他无缓冲查询处于活动状态时，无法执行查询。考虑使用PDOStatement :: fetchA...
2021-01-28 00:11

光合固氮的博客 but I've read the answers to many of the questions and still cannot understand why I am receiving this error: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General ...
未捕获的异常PDOException，即使语句在try / catch块中 php
2019-02-13 02:28

回答 1 已采纳 The problem turned out to be missing a backslash in a calling method. I had prepended the backsla
带有消息'SQLSTATE [HY000]的未捕获异常'PDOException' php sql
2012-07-08 16:35

回答 4 已采纳 Please add include('config.php');
SQLSTATE [HY000] [2002]连接被拒绝 - 引起：PDOException php
2015-01-30 03:11

回答 2 已采纳 host=myURL ?? try host=localhost Unless you are using a different machine for the mysql server, b
PHP基础补全系列：异常处理
2016-12-06 18:20

子在梦中曰的博客异常处理在PHP里也是个很有争议的问题，记得之前做项目的时候，...异常处理的基本使用扩展中抛出的异常，以PDO举例将错误信息委托给异常处理一些需要注意的tips：可以使用set_exception_handler自定义异常
未捕获PDOException：在PDOStatement对象上使用fetchAll（）时SQLSTATE [HY000] mysql php
2016-01-23 08:07

回答 1 已采纳 You should use query and exec for one SQL statement at a time: $db->exec("USE mydatab"); $resu
Yii2 解决2006 MySQL server has gone away问题
2019-08-30 14:13

liangpz521的博客 SQLSTATE[HY093]: Invalid parameter number: no parameters were bound 说明我们的sql没有绑定参数。为什么会出现这个问题？仔细阅读yii\db\Command的queryInternal()和execute()方法，发现他们都需要执行...
Yii 数据库重连告别General error: 2006 MySQL server has gone away
2016-10-21 16:24

SaneFuture的博客 exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away. The SQL statement executed was: INSERT INTO ...
mysql pdo in_PDO 用法学习
2021-01-27 17:35

XingXin-C的博客 1、安装扩展 php_pdo.dll2、安装驱动 php_pdo_mysql.dlllinux 编译时参数：--with-pdo=mysql=/usr/local/mysql三个类：PDO类，数据库连接有关(连接、执行sql)PDOStatement 处理结果集PDOException 异常处理类一些...
pdo的使用
2018-07-01 11:11

weixin_30871701的博客 PDO 用法学习 PDO: php data object数据库访问抽象层... linux 编译时参数：--with-pdo=mysql=/usr/local/mysql 三个类：PDO类，数据库连接有关（连接、执行sql）PDOStatement 处理结果集PDOException 异常处...
php的pdo用法
2016-04-24 22:12

weixin_33854644的博客 PDO 用法学习转自：思齐-pdo用法 PDO: php data object数据库访问... linux 编译时参数：--with-pdo=mysql=/usr/local/mysql 三个类：PDO类，数据库连接有关（连接、执行sql）PDOStatement 处理结果集PDOEx...
PDO 用法学习
2016-01-09 02:14

weixin_33921089的博客 PDO: php data object数据库访问... linux 编译时参数：--with-pdo=mysql=/usr/local/mysql 三个类：PDO类，数据库连接有关（连接、执行sql）PDOStatement 处理结果集PDOException 异常处理类一些常量相比mysql...
没有解决我的问题, 去提问

悬赏问题

¥100 set_link_state
¥15 虚幻5 UE美术毛发渲染
¥15 CVRP 图论物流运输优化
¥15 Tableau online 嵌入ppt失败
¥100 支付宝网页转账系统不识别账号
¥15 基于单片机的靶位控制系统
¥15 真我手机蓝牙传输进度消息被关闭了，怎么打开？(关键词-消息通知)
¥15 装 pytorch 的时候出了好多问题，遇到这种情况怎么处理？
¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
¥15 手机接入宽带网线，如何释放宽带全部速度

未捕获的异常'PDOException with message'SQLSTATE [HY000] [2013]

1条回答 默认 最新

悬赏问题

1条回答默认最新