编译安装PDO_MYSQL拓展模块，总是提示No such file or directory

最新推荐文章于 2021-09-10 09:24:14 发布
最新推荐文章于 2021-09-10 09:24:14 发布
阅读量1.8k 收藏
点赞数
分类专栏： php Mysql 文章标签： php mysql pdo
本文介绍了解决PDO_MYSQL模块编译过程中遇到的错误，主要是由于找不到MySQL头文件导致的问题。通过创建软链接将MySQL头文件路径映射到默认搜索路径下，可以有效解决这一问题。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

编译安装PDO_MYSQL拓展模块，总是提示

1
2
3
4
5
6
7
In file included from /data0/software/PDO_MYSQL-1.0.2/pdo_mysql.c:31:
/data0/software/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:25:19: error: mysql.h: No such file or directory
In file included from /data0/software/PDO_MYSQL-1.0.2/pdo_mysql.c:31:
/data0/software/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:36: error: expected specifier-qualifier-list before ‘MYSQL’
/data0/software/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:48: error: expected specifier-qualifier-list before ‘MYSQL_FIELD’
/data0/software/PDO_MYSQL-1.0.2/php_pdo_mysql_int.h:53: error: expected specifier-qualifier-list before ‘MYSQL_RES’
make: *** [pdo_mysql.lo] Error 1


这是因为这是因为在编译时需要 MySQL 的头的文件。而它按默认搜索找不到头文件的位置，所以才出现这个问题。通过软连接把MySQL头文件对应到/usr/local/include/下就好

比如你的MySQL安装文件位于/usr/local/mysql，那么就执行以下命令：

# ln -s /usr/local/mysql/include/* /usr/local/include/


--with-pdo-mysql=_php访问mysql接口pdo-mysql安装
weixin_39889329的博客
01-19 1084
php编译的时候加了这个--with-pdo-mysql=mysqlnd和--with-mysql=mysqlnd了，如果php编译时候加了就不用安装；如下说明已经安装了，有了，就不需要安装了，安装了也不会错误的，两个兼容的。[root@web01 opcache]# /application/php/bin/php -i|grep configureConfigure Command =>...
Yii PDO::__construct(): [2002] No such file or directory
07-05 3085
今天按装pear插件时，使用了php的default.ini覆盖了php.ini，后来打开yii的一个项目时就报下面的错误了。 PDO::__construct(): [2002] No such file or directory (trying to connect via unix://pathto/mysql.sock) 很明显，pdo配置错误，find查找到mysql.sock，更改
fatal error: mysql/mysql.h: No such file or directory
WiLL_2015的博客
10-17 1992
是因为没有安装mysql的相关链接库 解决方法： ubuntu下执行：apt-get install libmysqlclient-dev 转载于:https://www.cnblogs.com/caoyingjie/p/4030733.html
PDO连接数据库报错：SQLSTATE[HY000] [2002] No such file or directory
youcijibi的博客
08-10 4306
PDO连接数据库报错：“SQLSTATE[HY000] [2002] No such file or directory”。     出现这个问题的原因是PDO无法找到MySQL.sock或者mysqld.sock。     解决方法1：找到相应的.sock文件，并设置PHP.ini文件中的pdo_mysql.default_socket的值为.sock文件的路径。 pdo_my
mysql,mysqli,pdo方式连接数据库[no such file or directory]
yi_an的博客
03-04 963
header在air上，用MySQLi方式连接数据库就出现这个问题了，原来是mac系统配置MySQL环境的时候丢失系统的mysql.socket造成的，大概的意思就是。你用php连接MySQL的时候，需要一个mysql.socket文件，但是这个文件并没有能够正确的在你的php.ini文件中映射，路径不对，暂且这么理解吧，我不求甚解了。环境操作系统:mac os解决方案1、找到php.ini fin
PHP Warning: PHP Startup: Unable to load dynamic library 'bz2.so' (tried: /usr/lib64/php/modules/bz2.so (/usr/lib64/php/modules/bz2.so: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/bz2.so.so (/usr/lib64/php/modules/bz2.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'pdo.so' (tried: /usr/lib64/php/modules/pdo.so (/usr/lib64/php/modules/pdo.so: undefined symbol: _zval_ptr_dtor), /usr/lib64/php/modules/pdo.so.so (/usr/lib64/php/modules/pdo.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_mysql.so' (tried: /usr/lib64/php/modules/pdo_mysql.so (/usr/lib64/php/modules/pdo_mysql.so: undefined symbol: _zval_copy_ctor_func), /usr/lib64/php/modules/pdo_mysql.so.so (/usr/lib64/php/modules/pdo_mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'bz2' (tried: /usr/lib64/php/modules/bz2 (/usr/lib64/php/modules/bz2: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/bz2.so (/usr/lib64/php/modules/bz2.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'calendar' (tried: /usr/lib64/php/modules/calendar (/usr/lib64/php/modules/calendar: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/calendar.so (/usr/lib64/php/modules/calendar.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'ctype' (tried: /usr/lib64/php/modules/ctype (/usr/lib64/php/modules/ctype: cannot open shared object file: No such file or directory), /usr/lib64/php/modules/ctype.so (/usr/lib64/php/modules/ctype.so: cannot open shared object fil
03-15
对于pdo和pdo_mysql扩展，可能需要安装MySQL的开发包，比如php-mysqlnd或mysql-devel，并且在php.ini中同时启用pdo和pdo_mysql。此外，安装后需要重启PHP服务（如php-fpm或Apache）使配置生效。 用户提供的引用[3]...
zabbix No such file or directory
02-11
当在CentOS 7.5上源码编译安装Zabbix 4.0时，如果遇到`fatal error: mysql.h: No such file or directory`错误，则表明缺少MySQL开发包中的头文件。可以通过安装相应的软件包来解决这个问题[^1]。 对于基于RPM的...
Cannot load Zend OPcache - it was already loaded PHP Warning: PHP Startup: Unable to load dynamic library 'mbstring' (tried: /usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring: cannot open shared object file: No such file or directory), /usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring.so (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 Warning: PHP Startup: Unable to load dynamic library 'mbstring' (tried: /usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring: cannot open shared object file: No such file or directory), /usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring.so (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/mbstring.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'zip' (tried: /usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip: cannot open shared object file: No such file or directory), /usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip.so (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 Warning: PHP Startup: Unable to load dynamic library 'zip' (tried: /usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip: cannot open shared object file: No such file or directory), /usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip.so (/usr/local/lib/php/extensions/no-debug-non-zts-20230831/zip.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 error: 'intl' does not exist usage: /usr/local/bin/docker-php-ext-enable [options] module-name [module-name ...] ie: /usr/local/bin/docker-php-ext-enable gd mysqli /usr/local/bin/docker-php-ext-enable pdo pdo_mysql /usr/local/bin/docker-php-ext-enable --ini-name 0-apc.ini apcu apc Possible values for module-name: libphp83_dm.so opcache.so pdo_mysql.so php83_pdo_dm.so sodium.so Some of the above modules are already compiled into PHP; please check the output of "php -i" to see which modules are already loaded.
06-05
如果ta继续用5.6，至少应该提醒编译时加上--enable-opcache=no来规避重复加载问题。 根据您的PHP容器环境(Discuz X3.4 + PHP 5.6.40)和模块加载情况[^1][^2]，以下是完整解决方案： ### 一、解决扩展未加载问题...
[ERRO] 20250711 15:19:07.966044 [t1gm_presettle] failed to connect mysql, use:0.00sec, msg:Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory, code:-2059, svr:localhost:3306, db:A5_Fund, user:a5_ops@pubfund#mgr_pubfund, tx_isolation:serializable, conn:0x7faeb000dad0. [WARN] 20250711 15:19:07.990900 [t1gm_presettle] (01000)adapter failed to login database, name:A5_Fund, use:0.22s, msg:Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory [ERRO] 20250711 15:19:07.991397 [t1gm_presettle] (01744)failed to start service. svcname:t1gm_presettle, use:0.22sec. [INFO] 20250711 15:19:07.992583 [t1gm_presettle] service start failed. load adapter:libadp_aboss.so,ABOSS,A5_Fund,Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
最新发布
07-12
* **PHP (PDO, mysqli)：** 确保 PHP 的 MySQL 扩展（通常是 `mysqli` 或 `pdo_mysql`）是针对 MySQL 8.0+ 客户端库编译的，或者使用 `mysqlnd` 驱动并更新到支持新插件的 PHP 版本。 * **其他语言/框架：** 查阅...
编译安装pdo_mysql
u014062332的专栏
06-15 728
今天需要使用mysql的pdo，所以就使用
编译安装的php 安装pdo_mysql扩展
weixin_42878826的博客
01-26 450
现在PHP自带pdo_mysql扩展 1.进入PHP源文件解压包 cd /usr/local/src/php5.6.24/ext/pdo_mysql 执行phpize 命令 /usr/local/php/bin/phpize 编译 ./configure --with-php-conf...
初始化数据库报错-bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory
淘小欣的博客
02-24 2746
安装 MySQL 初始化时， 执行：./mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.6.51 --datadir=/usr/local/mysql-5.6.51/data时， 报错如下： -bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory 分析原因：缺 perl perl-devel包。 解决办法：
安装mysql，错误：-bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or direct
热门推荐
龙哥(webnum)说的，每天进步一点点，总有一天会实现梦想！
07-28 1万+
centos6 ：安装mysql 5.6 提示错误：-bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory 解决办法：yum -y install perl perl-devel
-bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory
Meteor31的博客
01-12 797
安装 MySQL 初始化时， 执行：./scripts/mysql_install_db --user=mysql 时，报错如下： ` -bash: ./scripts/mysql_install_db: /usr/bin/perl: bad interpreter: No such file or directory 原因：缺 perl perl-devel包。 解决办法： yum install -y perl perl-devel 安装后执行mysql初始化命令继续报错： FATAL ERROR:
PHP7.4编译安装问题解决及各依赖安装
qq_16174727的博客
09-10 4603
1、下载并解压 wget https://tls.mbed.org/download/mbedtls-2.16.3-gpl.tgz tar -xf mbedtls-2.16.3-gpl.tgz cd mbedtls-2.16.3 备用下载地址：https://down.24kplus.com/linux/mbedtls/mbedtls-2.16.3-gpl.tgz 2、编译安装 make make DESTDIR=/usr install ldconfig 如果出现make[1]:pyth..
pdo mysql连接时报[2002] No such file or directory
weixin_33738555的博客
07-20 492
将PDO连接中的dsn的host由“localhost”改为“127.0.0.1”即可
php7安装pdo_mysql扩展_Centos安装php7之pdo_mysql扩展
weixin_28778547的博客
01-19 880
环境：Centos7 + php7.3 + mysql5.7开始下面的步骤前，确定php7.3已经安装成功。进入php7.3的解压包，找到 ext/pdo_mysql目录，打开，运行：/usr/local/php/bin/phpize./configure--with-php-config=/usr/local/php/bin/php-config--with-pdo-mysql-dir=/u...
Magento环境PDO_mysql扩展安装指南
安装pdo_mysql扩展通常分为编译安装和使用PECL安装两种方式： ##### 编译安装 - 解压下载的pdo_mysql扩展源码包。 - 打开终端，切换到源码包目录。 - 运行以下命令编译扩展： ```bash phpize ./configure --with-...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值