PDO连接时,提示"unknown mysql server host"
来源:互联网 发布:招聘网络总监 编辑:程序博客网 时间:2024/05/21 17:28
在 CentOS7 上运行项目,但是不断的提示报错“SQLSTATE[HY000] [2005] Unknown MySQL server host ‘127.0.0.1:3306’ (110)”,找到报错位置后,发现代码如下:
$dsn = "mysql:host=127.0.0.1:3306;dbname=test";try { $pdo = new PDO($dsn, root, root); //初始化一个PDO对象,就是创建了数据库连接对象 $pdo->exec("SET NAMES 'utf8';"); self::$link[$rand] = $pdo;} catch (PDOException $e) { if($auto_connect) { //省略 } die ($e->getMessage() . "<br/>");}
参考 PDO connect to localhost (unknown mysql server host) ,把第一行代码的端口修改下,就可以运行了,奇怪的是在windows下面,这样写却没有问题。
$dsn = "mysql:host=127.0.0.1;port=3306;dbname=test";
0 0
- PDO连接时,提示"unknown mysql server host"
- php PDO连接时,提示"unknown mysql server host"
- Unknown MySQL server host 'localhost'
- ERROR 2005 (HY000): Unknown MySQL server host
- Unknown MySQL server host 'localhost' (0)
- Unknown MySQL server host 'localhost' (0)
- 2005 - Unknown MySQL server host 'localhost' (0)
- 28.Unknown MySQL server host 'localhost'(0)
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server(...
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server(转)
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 远程连接MYSQL提示 Host *** is not allowed to connect to this MySQL server
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- 远程连接MySQL数据库提示错误Host is not allowed to connect this MySQL server
- 解决远程连接MYSQL提示Host is not allowed to connect to this MySQL server
- Java压缩和解压文件工具类ZipUtil
- Echarts-axislabel文字过长导致显示不全或重叠
- log4j.properties读取webapp.root值失败,导致的setFile(null,..)的解决方案
- Android assets文件夹资源访问
- 冲突域与广播域(区别、知识要点)
- PDO连接时,提示"unknown mysql server host"
- You need to use a Theme.AppCompat theme (or descendant) with this activity.
- BZOJ2725 [Violet 6]故乡的梦
- Android 数据传递之Application、Intent、static
- 超200亿元!乐视超级电视发布三大战略、四个核心目标
- MyBatis的插件安装与自动生成代码
- 输入、输出函数说明以及精度说明符的使用方法
- 字符与字节有什么区别
- <context:annotation-config> 、<mvc:annotation-driven>的区别