| View previous topic :: View next topic |
| Author |
Message |
markpearson
Joined: 24 May 2005
Posts: 2
Location: Richmond, IN, USA
|
 Posted: Tue Feb 07, 2006 19:09 Post subject: Apparent version mismatch php & MySQL |
 |
|
OK, so I'm running Mac OS X tiger 10.4.4 on a Mac mini and I need to have php running with postgres & mysql support. Getting postgres going has been a piece of cake -- MySQl however has been a nightmare.
I downloaded and configured the Entropy php 4.3.11 with built in MySQL support:
PHP Version 4.3.11
www.entropy.ch Release 1
I'm using the MySQL that is rolled in to OS X server, 4.1.13a.
When I run this code:
| Code: |
// Connecting, selecting database
$link = mysql_connect('localhost', 'root', 'password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('test') or die('Could not select database');
?> |
I get the following error message:
| Code: |
"Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client." |
This has something to do with MySql change of password authentication mechanisms I think. So what do you recommend? Update php to version 5? Update Mysql to 5 as well?
This is driving me bonkers ....
Cheers
Mark |
|
| Back to top |
|
 |
kfaulhaber
Joined: 06 Aug 2003
Posts: 110
Location: ~/Living Room
|
|
| Back to top |
|
|
markpearson
Joined: 24 May 2005
Posts: 2
Location: Richmond, IN, USA
|
| Posted: Tue Feb 07, 2006 20:58 Post subject: Cock up |
|
|
Thank you squire. I should have known that one.
So I guess I'll update php to version 5 then. What I'm not sure though is whether all the OS apps then need to use 'mysqli' extension.
Mark
_________________
Dr Mark H Pearson
Instructional Technologist
Earlham College
Richmond, IN 47373 |
|
| Back to top |
|
|
kfaulhaber
Joined: 06 Aug 2003
Posts: 110
Location: ~/Living Room
|
| Posted: Tue Feb 07, 2006 21:06 Post subject: Re: Cock up |
|
|
see below (submitted before I was finished)
Last edited by kfaulhaber on Tue Feb 07, 2006 21:20; edited 1 time in total |
|
| Back to top |
|
|
kfaulhaber
Joined: 06 Aug 2003
Posts: 110
Location: ~/Living Room
|
| Posted: Tue Feb 07, 2006 21:18 Post subject: |
|
|
| markpearson wrote: | | What I'm not sure though is whether all the OS apps then need to use 'mysqli' extension. |
mysqli is not a requirement.
If your installation of PHP5 is configured using --with-mysql then any PHP applications won't have issues with the usual mysql functions. If you are using the Entropy package, this is the case. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
