In windows systems, the same error "unable to load dynamic library php_mysql.dll" will happen, if there's an old version of the file in the "windows\system32" folder.
Either remove it or update it.
설치
컴파일 하려면, 간단히 --with-mysql[=DIR] 설정 옵션을 사용하고 선택적인 [DIR]은 MySQL 설치 디렉토리를 지시합니다.
MySQL 확장이 MySQL 4.1.0 이상을 지원하지만, 이 버전이 제공하는 추가 함수는 지원하지 않습니다. 이러한 기능을 사용하려면, MySQLi 확장을 사용하십시오.
mysqli 확장과 함께 mysql 확장을 설치하려 할 때는, 혼동을 피하기 위해 같은 클라이언트 라이브러리를 사용해야 합니다.
리눅스 시스템에 설치
PHP 4
--with-mysql 옵션은 기본값으로 활성화 되어 있습니다. 이 기본 동작은 --without-mysql 설정 옵션으로 끌 수 있습니다. MySQL 설치 DIR 경로를 지정하지 않고 MySQL이 활성화되면, PHP는 번들한 MySQL 클라이언트 라이브러리를 사용합니다.
사용자가 MySQL을 사용하는 다른 어플리케이션(예를 들면, auth-mysql)을 사용하면 번들 라이브러리를 사용하지 말아야 하고, 다음과 같이 MySQL 설치 디렉토리를 지정해야 합니다: --with-mysql=/path/to/mysql . 이는 PHP가 MySQL이 설치한 클라이언트 라이브러리를 사용하도록 강제하여, 충돌을 피합니다.
윈도우 시스템에 설치
PHP 4
PHP MySQL 확장은 PHP에 컴파일 되어 있습니다.
PHP 5+
MySQL은 더 이상 기본 확장이 아니므로, php.ini에서 php_mysql.dll DLL을 활성화해야 합니다. 또한, PHP가 MySQL 클라이언트 라이브러리에 접근할 수 있어야 합니다. 윈도우 PHP 배포판에 포함되어 있는 libmysql.dll 파일이 윈도우 시스템 PATH에 있어야 합니다. 이를 위해선 "윈도우에서 PHP 디렉토리를 PATH에 추가하는 방법" FAQ를 읽어보십시오. libmysql.dll을 윈도우 시스템 디렉토리에 복사해도 작동하나(시스템 디렉토리는 기본적으로 시스템 PATH에 포함되기 때문), 권장하지 않습니다.
어떠한 PHP 확장을 활성화 하려면(php_mysql.dll 등), PHP 지시어 extension_dir을 PHP 확장이 위치한 디렉토리로 설정해야 합니다. 수동 윈도우 설치 안내를 참고하십시오. PHP 5의 extensino_dir값 예시는 c:\php\ext입니다.
Note:
웹 서버를 시작할 때 다음과 비슷한 오류가 발생할 수 있습니다: "Unable to load dynamic library './php_mysql.dll'" 이는 php_mysql.dll이나 libmysql.dll을 시스템에서 찾을 수 없을 경우입니다.
MySQL 설치 주의
Warning
레코드 확장과 함께 이 확장을 로드할 때, PHP에서 충돌과 시작 문제가 발생할 수 있습니다. 자세한 정보는 레코드 확장을 참고하십시오.
Note:
latin(기본값) 외의 문자셋이 필요하면, 문자셋 지원으로 컴파일한 외부(번들이 아닌) libmysql을 설치해야 합니다.
add a note
User Contributed Notes 7 notes
jonnus ¶
15 years ago
heneryville at gmail dot com ¶
13 years ago
I believe that this is happens especially with Windows 7. As far I I've been able to tell XP and Vista come with this line enabled, but windows 7 comments it out and notes that the DNS will handle this.
Steve in Weston-Super-Mare ¶
12 years ago
I had problems when moving from a version of PHP that used the isapi dll to the fast cgi version. The script to register the script maps compained that there was already a script map in place.
I went to the IIS control panel, right clicked on websites and removed the php association in the Home Directory | Configuration screen.
However, the fastcgi script still complained about existing script map. Finally I tracked it down, I had to right click on Default Web Site and clear out the php mappings from there too.
Then it all worked, except that for some strange reason, the php.ini file that gets picked up is the one from my old PHP directory, not the latest upgrade one. But this can be detected by running phpinfo which shows the loaded php.ini file so I knew which one to amend with the fastcgi options.
Bit of a hassle to figure it all out but it does work in the end.
mail dot umlcat at gee mail dot com ¶
11 years ago
Could not install mysql, on windows, had several conflicts or bugs.
In order to solve it:
* Used the "libmysql.dll" provided by PHP zip files, not the one that comes with Mysql, the mysql file had to be moved or deleted from its folder. Put it on the "apache/bin" folder, altought some use it in "windows" folder.
* Originally, moved "*mysql*.dll" files from its extension folder, and returned back.
* enabled mysql driver extensions in the "php.ini" file, but also enabled some extensions, that seemed not to be required, but, it did, like "php_openssl.dll" or "php_pdo.dll" on an early version of php.
Added the "PHPIniDir xxx"" to the "httpd.conf" apache config. file, where xxx is the path to the folder where the "php.ini" file is located, and make sure its the same.
Be warned, that this fixes, may help or not, for your installation, since there are many ways to configure the same thing (to solve a problem).
buzzr515 at gmx dot de ¶
13 years ago
i've experienced a similar (if not the same) problem.
to enable the mysql_... and mysqli_... funtionality, i opened the php.ini file to uncomment the following lines:
;extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_pdo_mysql.dll
but phpinfo() still stated that no mysql extensions were loaded.
i tried the fixes and suggestions above with no success.
so i invoked the windows shell and typed ("Path" environment variable set to the PHP & MySQL directories):
php.exe -m
this returned the following error: "PHP Startup: Unable to load dynamic library 'C:\php5\php_mysql.dll' - Module not found."
this told me that PHP didn't recognize what i thought was the extensions directory. it searched all other places first (sys-dir, workin'-dir, the MySQL "bin" dir because of the "Path" variable set, and even a curious directory "C:\php5" that doesn't even exist on my mashine) but not the expected "ext" directory.
so the fix was to go to "php.ini" again and uncomment the following line:
;extension_dir="ext"
this fixed it for me.
so if module loading is done improperly, first of all check the "Path" environment variable and the "php.ini" file - especially the "extension_dir" config value - and check if all values are set to their correct values.
hope this helps any1.
----------------------------------------
OS: Win7 Ultimate x86
Apache v2.2.16
PHP v5.3.3
MySQL v5.1.50
amatsak at gmail dot com ¶
14 years ago
I have experienced exactly the same problem as flo_stefi at yahoo dot com below. It appears that instead of loading libmysql.dll that came with the PHP package, the PHP engine was loading libmySQL.dll located in MySQL's bin directory, which was causing Apache to crash.
I fixed the problem by renaming MySQL's libmySQL.dll into libmySQL_renamed.dll. Now PHP loads the library that came with its package and everything works fine.
o dot kochetilov at gmail dot com ¶
12 years ago
Please note that libmySQL.dll in MySQL bin directory should be renamed in order to use right library (that comes with PHP).
