Using Mysql 5.0 Functions with PHP
Moderator: General Moderators
OK. I download and install the version 4.4.4. I extract the package to C:\PHP and follow the instrucctions of the PHP Manual to Manual Installation. According with this Manual, I translate all the files located in DLL and SAPI folders to the main folder (PHP). I add C:\PHP to the Windows Path and use the PHP.INI-recommended. Aditional I include the line: doc_root = c:\inetpub\wwwroot in PHP.INI because I work with IIS. That's my installation.
Thanks, volka.
Thanks, volka.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
The MySQL client API in PHP4 works with MySQL up to 4.0. As of 4.1, their password hashing algorithm changed. You can adjust a setting in the my.conf file to make MySQL use the old password (16 bit) hash, although the new hash is much more secure. I would seriously consider moving up to PHP 5 and MySQL 5.
You are rigth about the versions. I use mySql 5.0 but the problem with PHP is that my Server Hosting (1planhost) don't have the upgrade to PHP 5.0 I'm waiting for this change, but they have mySql 5.0
A last question:
If I use the "famous" SET PASSWORD FOR ’some_user’@’some_host’ = OLD_PASSWORD(’mypass’); I need also to modify the my.conf?
(I don't find my.conf; is just like my.ini? )
Thanks...
A last question:
If I use the "famous" SET PASSWORD FOR ’some_user’@’some_host’ = OLD_PASSWORD(’mypass’); I need also to modify the my.conf?
(I don't find my.conf; is just like my.ini? )
Thanks...
Sorry if I insist but I've downloaded http://www.php.net/get/php-4.4.4-Win32. ... m/a/mirror
There's a libmysql.dll in that package. In order to you the php_mysql extension you must have done something so windows can find this dll.
Maybe you did it with a previous installation of php. Something like copying this dll to c:\windows or similar.
If you just replace this dll (the one you've copied) by the one in your mysql directory there's nothing else to do. php 4 will use this (new) dll and therefore use the new password encryption - no sweat, no need to change any data within the database.
There's a libmysql.dll in that package. In order to you the php_mysql extension you must have done something so windows can find this dll.
Maybe you did it with a previous installation of php. Something like copying this dll to c:\windows or similar.
If you just replace this dll (the one you've copied) by the one in your mysql directory there's nothing else to do. php 4 will use this (new) dll and therefore use the new password encryption - no sweat, no need to change any data within the database.
In the app's all ok (according with your post) but remain a problem with the phpMyAdmin:
The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
I found any solutions in Internet like
"Did you put the correct path to the directory where the dll files are residing, here:
extension_dir =c:\php\extensions (for me)
And did you uncomment this:
;extension=php_mbstring.dll "
I made all the changes but the problem persists
The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
I found any solutions in Internet like
"Did you put the correct path to the directory where the dll files are residing, here:
extension_dir =c:\php\extensions (for me)
And did you uncomment this:
;extension=php_mbstring.dll "
I made all the changes but the problem persists
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA