spiderman
Posts: 22
|
| Posted: 10/07/2005, 7:51 AM |
|
New install of the lastest mysql 4 .1.14 and I get this message that claims I am running an older version of mysql client?
I download the latest versions (recommended) of each software
Apache
mysql
php
I can run the examples without getting this error message but when I create an application from scratch and build an authentication screen it gives me this message
Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\htdocs\thematrix\db_mysql.php on line 100
Database error: pconnect(localhost:3306, root, $DBPassword) failed.
MySQL Error: 0 ()
Session halted.
The solution on the Mysql website tells me to upgrade to a version of 4.1.1 or newer I have version 4.1.14 unless the client part is different and how would I tell? I am using ODBC 3.51 if that is a problem?
But it just talks about the client? I don't know where to find this info?
And one would think that if they download the lastest recommended version that it would be included?
|
 |
 |
?
|
| Posted: 10/07/2005, 9:11 AM |
|
I found out that you have to select ODBC in the server connection dialog box then mysql -- I was selecting mysql -- I don't ODBC and would like to be able to code the connection direct to the server... I have not tried it yet... That will come later after I get up to speed on ccs.
|
|
|
|
DonB
|
| Posted: 10/07/2005, 9:16 AM |
|
MySQL switched it's password-encryption to be more secure. Check the MySQL
documentation website for the function "OLD_PASSWORD" and you will find a
complete explanation and instructions for getting around this problem.
I had it happen to me, and tried going the 'new client' route but couldn't
fix it that-a-way.
--
DonB
http://www.gotodon.com/ccbth
|
|
|
|
peterr
Posts: 5971
|
| Posted: 10/07/2005, 12:36 PM |
|
Please also see this article tat describes connecting to MySQL 4.1: http://support.yessoftware.com/kb_article.asp?article_id=75
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
