Home Backend Development PHP Tutorial PHP无法正确载入Mysql库,

PHP无法正确载入Mysql库,

Jun 13, 2016 pm 01:14 PM
amp apache mysql php quot

PHP无法正确载入Mysql库,求助各位高手!!!
各软件版本:
apache:2.2.22
PHP:5.2.17 
Mysql:5.5.23

现在apache已经能正常解析.php文件,但phpinfo()却一直无法正确显示载入了mysql库。
我的php.ini放在php的安装路径,配置有:
extension_dir = "./ext"
extension=php_mysql.dll

./ext里确实有php_mysql.dll文件。
后来我上网查,说是要在system32中也放入php_mysql.dll文件,然后我也复制了一份过去,但还是不行。

小弟新手,以前都是用的AppServ,第一次自己安,弄半天都没弄好,请各位高手帮帮忙!不甚感激!!!

------解决方案--------------------
检查一下phpinfo内的 php.ini路径是不是你修改的这个.另外不仅仅是php_mysql.dll需要复制好像还有个libmysql.dll
也是需要复制到system32下的.试一下看看. win下配置环境我也变得很陌生了...

------解决方案--------------------
在 window 环境中
1、不要复制任何文件(绿色安装)
因为 apache、php、mysql 都可以不依赖注册表运行

2、模块方式的 php 的 extension_dir 应使用绝对路径(可不要盘符),相对路径 ./ext 是给 php.exe 用的
否则驻留在内存中的 php5apache2_2.dll 将找不到相应的目录,无法指示 php5ts.dll 加载扩展库

3、apache 配置 php 的基本参数(替换路径为你真实路径)
PHPIniDir "/AMP/php536"
LoadFile "/AMP/php536/php5ts.dll"
LoadModule php5_module "/AMP/php536/php5apache2_2.dll"
addtype application/x-httpd-php .php

4、备用知识:
设 
apache 被安装于 /AMP/apache2 下
mysql 被安装与 /AMP/mysql 下
那么将 /AMP 复制到U盘上就可使环境变成便携的了
启动时执行
start /B "Apache" "\AMP\apache2\bin\httpd.exe"
start /B "Mysql" "\AMP\mysql\bin\mysqld.exe" --defaults-file="\AMP\mysql\my.ini"
停止时执行
tskill httpd
tskill mysqld

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

MySQL: The Ease of Data Management for Beginners MySQL: The Ease of Data Management for Beginners Apr 09, 2025 am 12:07 AM

MySQL is suitable for beginners because it is simple to install, powerful and easy to manage data. 1. Simple installation and configuration, suitable for a variety of operating systems. 2. Support basic operations such as creating databases and tables, inserting, querying, updating and deleting data. 3. Provide advanced functions such as JOIN operations and subqueries. 4. Performance can be improved through indexing, query optimization and table partitioning. 5. Support backup, recovery and security measures to ensure data security and consistency.

Can I retrieve the database password in Navicat? Can I retrieve the database password in Navicat? Apr 08, 2025 pm 09:51 PM

Navicat itself does not store the database password, and can only retrieve the encrypted password. Solution: 1. Check the password manager; 2. Check Navicat's "Remember Password" function; 3. Reset the database password; 4. Contact the database administrator.

How to create navicat premium How to create navicat premium Apr 09, 2025 am 07:09 AM

Create a database using Navicat Premium: Connect to the database server and enter the connection parameters. Right-click on the server and select Create Database. Enter the name of the new database and the specified character set and collation. Connect to the new database and create the table in the Object Browser. Right-click on the table and select Insert Data to insert the data.

Navicat cannot connect to MySQL/MariaDB/PostgreSQL and other databases Navicat cannot connect to MySQL/MariaDB/PostgreSQL and other databases Apr 08, 2025 pm 11:00 PM

Common reasons why Navicat cannot connect to the database and its solutions: 1. Check the server's running status; 2. Check the connection information; 3. Adjust the firewall settings; 4. Configure remote access; 5. Troubleshoot network problems; 6. Check permissions; 7. Ensure version compatibility; 8. Troubleshoot other possibilities.

Navicat connects to database error code and solution Navicat connects to database error code and solution Apr 08, 2025 pm 11:06 PM

Common errors and solutions when connecting to databases: Username or password (Error 1045) Firewall blocks connection (Error 2003) Connection timeout (Error 10060) Unable to use socket connection (Error 1042) SSL connection error (Error 10055) Too many connection attempts result in the host being blocked (Error 1129) Database does not exist (Error 1049) No permission to connect to database (Error 1000)

How to create a new connection to mysql in navicat How to create a new connection to mysql in navicat Apr 09, 2025 am 07:21 AM

You can create a new MySQL connection in Navicat by following the steps: Open the application and select New Connection (Ctrl N). Select "MySQL" as the connection type. Enter the hostname/IP address, port, username, and password. (Optional) Configure advanced options. Save the connection and enter the connection name.

How to execute sql in navicat How to execute sql in navicat Apr 08, 2025 pm 11:42 PM

Steps to perform SQL in Navicat: Connect to the database. Create a SQL Editor window. Write SQL queries or scripts. Click the Run button to execute a query or script. View the results (if the query is executed).

How to connect to local mysql in navicat How to connect to local mysql in navicat Apr 09, 2025 am 07:45 AM

To connect to a local MySQL database using Navicat: Create a connection and set the connection name, host, port, username, and password. Test the connection to make sure the parameters are correct. Save the connection. Select a new connection from the connection list. Double-click the database you want to connect to.

See all articles