View previous topic :: View next topic |
Author |
Message |
photobank -
Joined: 27 Apr 2004 Posts: 9 Location: thailand
|
Posted: Wed Sep 07, 2005 7:40 am Post subject: MySQL+PHP |
|
|
trying to use ApreliumServer+php+MySQL.
This is what I get when trying to connect to database.
Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\1web\query7.php on line 29
Could not connect to Database.
any BRIGHT ideas?
Thank you
Alberto[color=#444444][/color] _________________ alberto |
|
Back to top |
|
 |
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Wed Sep 07, 2005 9:59 am Post subject: |
|
|
First of all you posted in the wrong forum; presumably by accident.
Second a quick forum search would have found the answer to this problem.
This error simply means that the php and mysql configuration you have used is not compatable. Download php5 and mysql 4.1 and try again. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
 |
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
|
Back to top |
|
 |
photobank -
Joined: 27 Apr 2004 Posts: 9 Location: thailand
|
Posted: Fri Sep 09, 2005 10:03 am Post subject: PHP5+MySQL |
|
|
Thank you for the answers and apologies for barging in the wrong forum.
Ashame the second post arrived late as it could have save me a day.
I did follow the Inquisitor suggestion and download PHP5 which (I can see you smiling) could not find PHP-MySQL functions. So I did browse the forum this time and got entangled in myPHPAdmin which proved to be a total waste of time. While messing around I realized that Window installer does NOT have extension .ddl on board (why? all it has to do is just unzip them), nor does it cares about, just in case you do have them.
Best way for me was to download both binaries and installer.exe packages
Unzip the binaries into c:\PHP and run installer specifying C:\PHP as well. This updates window Registry about php engine whereabouts.To call the extensions php does not use Registry though, but PHP.ini
This file is easy to configure, but I waisted hours to figure out where to put it once edited.
Not where advertised by the manual. It turned out it should go where "doc_root" is pointing in php.ini, say doc_root='c:\myweb'.Failing this defaults keep on being used; and no MySQL.
phpinfos() is usefull to see the location of the php.ini in use at the moment. Aprelium server should be configured as for instructions.I did not have to change Custom Environment Variables though. Regards. _________________ alberto |
|
Back to top |
|
 |
|