Heb mysql geinstalleerd, cdfoon geimporteerd, tabellen zijn aangemaakt, iis geinstalleerd, php geinstalleerd, shript file aangepast. En dan krijg ik de volgende foutmelding: Fatal error: Call to undefined function mysql_connect() in c:\Inetpub\wwwroot\fs2004.php on line 16
Op linux zal je php met mysql moeten configureren anders kan hij het denk ik niet vinden. Mogelijk werkt hetzelfde op Windows.
tar -zxvf php-4.3.4.tar.gz
cd php-4.3.4
./configure --with-apxs=/usr/local/fsh/var/apache/bin/apxs --with-mysql --with-config-file-path=/usr/local/fsh/var/apache/conf --enable-debug=no --enable-track-vars
make
make install
Nav jou gedowngrade naar een versie waar zeker (volgende de site dan) mysql ondersteuning inzit. Helaas pindakaas.
Krijg nu:
Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\fs2004.php on line 16
Could
A.2.3 Client does not support authentication protocol
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients.
To solve this problem, you should use one of the following approaches:
(…)
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR ‘some_user’@‘some_host’ = OLD_PASSWORD(‘newpwd’);
A.2.3 Client does not support authentication protocol
MySQL 4.1 and up uses an authentication protocol based on a password hashing algorithm that is incompatible with that used by older clients.
To solve this problem, you should use one of the following approaches:
(…)
Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:
mysql> SET PASSWORD FOR ‘some_user’@‘some_host’ = OLD_PASSWORD(‘newpwd’);[/quote]
wordt er met client het php script bedoelt of PhP zelf??
Ik heb sql 4.1 geinstalleerd en php 4.3.9. Dit alles onder XP.