MySQL+PHP

 
Post new topic   Reply to topic    Aprelium Forum Index -> PHP
View previous topic :: View next topic  
Author Message
photobank
-


Joined: 27 Apr 2004
Posts: 9
Location: thailand

PostPosted: Wed Sep 07, 2005 7:40 am    Post subject: MySQL+PHP Reply with quote

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 View user's profile Send private message Visit poster's website
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Wed Sep 07, 2005 9:59 am    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Thu Sep 08, 2005 4:09 pm    Post subject: Re: MySQL+PHP Reply with quote

photobank,

Install the preconfigured PHP5 package from http://www.aprelium.com/abyssws/php5win.html .
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
photobank
-


Joined: 27 Apr 2004
Posts: 9
Location: thailand

PostPosted: Fri Sep 09, 2005 10:03 am    Post subject: PHP5+MySQL Reply with quote

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 View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> PHP All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group