PHP Doku:: Installation - mysql.installation.html

Verlauf / Chronik / History: (1) anzeigen

Sie sind hier:
Doku-StartseitePHP-HandbuchFunktionsreferenzDatenbankerweiterungenAnbieterspezifische DatenbankerweiterungenMySQLInstallation/KonfigurationInstallation

Ein Service von Reinhard Neidl - Webprogrammierung.

Installation/Konfiguration

<<Anforderungen

Laufzeit-Konfiguration>>

Installation

For compiling, simply use the --with-mysql[=DIR] configuration option where the optional [DIR] points to the MySQL installation directory.

Although this MySQL extension is compatible with MySQL 4.1.0 and greater, it doesn't support the extra functionality that these versions provide. For that, use the MySQLi extension.

If you would like to install the mysql extension along with the mysqli extension you have to use the same client library to avoid any conflicts.

Installation on Linux Systems

PHP 4

The option --with-mysql is enabled by default. This default behavior may be disabled with the --without-mysql configure option. If MySQL is enabled without specifying the path to the MySQL install DIR, PHP will use the bundled MySQL client libraries.

Users who run other applications that use MySQL (for example, auth-mysql) should not use the bundled library, but rather specify the path to MySQL's install directory, like so: --with-mysql=/path/to/mysql . This will force PHP to use the client libraries installed by MySQL, thus avoiding any conflicts.

PHP 5.0.x, 5.1.x, 5.2.x

MySQL is not enabled by default, nor is the MySQL library bundled with PHP. Read this FAQ for details on why. Use the --with-mysql[=DIR] configure option to include MySQL support. You can download headers and libraries from » MySQL.

PHP 5.3.0+

In PHP 5.3.0 and above the MySQL-related database extensions use the MySQL Native Driver by default. This means that the MySQL Client Library (libmysql) is no longer required in order to support connection to a MySQL database. The extensions mysql, mysqli, and PHP_PDO_MYSQL are all enabled by default in PHP 5.3.0+, and all use the MySQL Native Driver by default. In each case no further installation steps are required in order to use these extensions, although you may want to set some preferences in php.ini depending on your requirements.

Installation on Windows Systems

PHP 4

The PHP MySQL extension is compiled into PHP.

PHP 5.0.x, 5.1.x, 5.2.x

MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying libmysql.dll to the Windows system directory also works (because the system directory is by default in the system's PATH), it's not recommended.

As with enabling any PHP extension (such as php_mysql.dll), the PHP directive extension_dir should be set to the directory where the PHP extensions are located. See also the Manual Windows Installation Instructions. An example extension_dir value for PHP 5 is c:\php\ext

Hinweis:

If when starting the web server an error similar to the following occurs: "Unable to load dynamic library './php_mysql.dll'", this is because php_mysql.dll and/or libmysql.dll cannot be found by the system.

PHP 5.3.0+

Please refer to these notes on installing MySQL support on PHP 5.3.0 and above.

MySQL Installation Notes

Warnung

Crashes and startup problems of PHP may be encountered when loading this extension in conjunction with the recode extension. See the recode extension for more information.

Hinweis:

If you need charsets other than latin (default), you have to install external (not bundled) libmysql with compiled charset support.


12 BenutzerBeiträge:
- Beiträge aktualisieren...
buzzr515 at gmx dot de
3.09.2010 18:13
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
titus at antennasystems dot com
28.06.2010 19:00
I ran into the soon to be infamous problem of upgrading to PHP 5.3.x.
The way I found to resolve the issue was to

1: Do "mysql_upgrade" on the server (to make MySQL compliant with MySQL 4.1+).

2: Modify my.cf to not use old passwords:
(Just comment out "old_passwords=1")
#old_passwords=1

3: Change the root password so you can properly connect to the server:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('enter_new_password_here');

http://dev.mysql.com/doc/refman/5.1/en/old-client.html
http://tinyurl.com/mysql-old-password

Taken from http://www.comsiteconstruction.com/blueonyx-modifications
samishiikihaku23 at gmail dot com
17.06.2010 20:36
I've checked all the 5.3 distribution files from http://windows.php.net/ for the "libmysql.dll" file that this article claims is in the distributions.

None of the 5.3 dist. supplies "libmysql.dll". Download the recent 5.2 release for the file.
heneryville at gmail dot com
30.04.2010 22:32
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.
jez300
10.03.2010 2:34
Windows 7 / Vista:

This took me hours to realise... If you receive the message:
Warning: mysql_connect(): [2002] A connection attempt failed because the connected party did not (trying to connect via tcp://localhost:3306)

You may need to map localhost to your IP address (127.0.0.1) which is used to find your Mysql server.

Edit {systemdrive}:\Windows\System32\drivers\etc

Make sure "127.0.0.1       localhost" isn't commented out with # at the begining of the line!

-----

You may also like to know that if you change from MySQL 32 bit to 64 bit and the Mysql service wont start you may need to rename or delete your Mysql data
{systemdrive}:\ProgramData\x MySQL\MySQL Server 5.1\data

Regards,

Jez.
amatsak at gmail dot com
22.06.2009 11:46
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.
flo_stefi at yahoo dot com
1.04.2009 14:10
I had a problem to make mysql work with php on Windows. Using mysql-5.1.32-win32 and php-5.2.9-1-win32-installer I've installed mysql and php. All seemed to be ok (phpinfo displayed the right information) but when running a basic script mysql_connect(..) the apache ends with a stupid error like "[Wed Apr 01 14:44:05 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.".
I manage to fix it by using instead of libMySQL.dll from mysql package another version (libmysql.dll) I had from a previous installation.
lobbanhousehold at gmail dot com
12.02.2009 4:05
I figured my problem why php and mysql weren't working together even though they worked independent of each other. PHP was configured with IIS 5.1 (XP) using the php5isapi.dll file.

I also set system variables in PATH adding the locations of both php and mysql folders. I also moved the mysql DLL files from ext folder to the root folder of php.

I discovered that php would not work with mysql if php folder was not located on the C:\ (i.e. C:\php). I also renamed the libmysql.dll that came with mysql so that the system would not see it, and moved the one that came with php to C:\WINDOWS\system32.

After I did this last paragraph i was able to see MySQL and MySQLi sections listed in phpinfo() which indicates MySQL is finally enabled
admin at kobashicomputing dot com
2.11.2008 8:02
Unfortunately this one bit me for a good half day.

Placing libmysql.dll in the php/ext directory did not work. I tested this under 5.6.2. You need to have it somewhere in the PATH or in SYSTEM or SYSTEM32. But to me this is very silly to force the user to have to setup environment variables or move DLLs around. It shouldn't have to go that far and be the responsibility of the setup program and/or developer.

I really think this issue could be solved doing this:
1) Installer/distribution bundle all three files together under one directory (ext) - php_mysql.dll/php_mysqli.dll/libmysql.dll

2) Developer goes into php_mysql.dll/php_mysqli.dll and in DllMain() on DLL_PROCESS_ATTACH:
  LoadLibrary ("./libmysql.dll");

Then you don't have to deal with this problem and neither do your users.

Kerry Kobashi
rogerc at clubsites dot net
20.07.2008 16:05
This error also occurs if the windows path entry for an older version of MYSQL appears before the path entry for a late version of php.  In which case the version of libmysl.dll in the MySQL bin directory will be found before the one bundled with php.  Reversing the system path entries so php is first fixes this problem.  e.g.
PATH= ...  c:\php;C:\Program Files\MySQL\MySQL Server 4.1\bin
Mahesh
13.06.2008 11:37
In windows systems, the error "unable to load dynamic library php_mysql.dll" also happens if there's an old version of the file libmysql.dll in the "windows\system32" folder.
jonnus
12.05.2008 14:42
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.



PHP Powered Diese Seite bei php.net
The PHP manual text and comments are covered by the Creative Commons Attribution 3.0 License © the PHP Documentation Group - Impressum - mail("TO:Reinhard Neidl",...)