Mysql Error

[Albino]

Hey,

can anyone explain this error and how to fix it please?

Its probably really simple, but i cant seem to get around it:

ERROR: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\Apache Group\Apache2\test\createmovie.php on line 10

thanks!

Todd

 

[cerebus]

MySQL uses a new authentification system as of 4.1. PHP 4.x does not support this.

Fix:
http://dev.mysql.com/doc/mysql/en/old-client.html

... or switch to PHP5 with mysqli

 

[axilant]

MySQL uses a new authentification system as of 4.1. PHP 4.x does not support this.

Fix:
http://dev.mysql.com/doc/mysql/en/old-client.html

... or switch to PHP5 with mysqli

:bingo:

 

[Albino]

so I pretty much need to upgrade php?

im using a book to learn php/mysql, and they use:

php 4.3.3 (im using 4.3.11 as I could find 4.3.3)
mysql 4.0.15a (im using mysql-essential-4.1.10a-win32 as it was recommended as what I needed)
is there any way to upgrade without going to v5 (php), and mysqli, as the book doesn't deal with them.

i tried setting my original password in the old style (OLD_PASSWORD), but it didnt seem to work.

Thanks

Todd

 

[axilant]

http://easyphp.org/telechargements/dn.php?F=easyphp1-7
That is a direct download for Easy PHP 1.7 (1.8 has a php compile bug)
This will install:
PHP
Mysql
Apache
PhpMyAdmin

I use this tool all the time.

Good luck, post if you need further help.

 

[edmarriner]

no get apache2triad ( http://apache2triad.net/ )

goto http://apache2triad.net/info.php to see what it installs

its brill and has all you need +more and one of the best things is it has a easy to use controll panel

:kickass:

go apache2triad !!!!

 

[axilant]

no get apache2triad ( http://apache2triad.net/ )

goto http://apache2triad.net/info.php to see what it installs

its brill and has all you need +more and one of the best things is it has a easy to use controll panel

:kickass:

go apache2triad !!!!

Its too bloated imo, i used it before... and its mainly for people who are making huge portals... and want a local place to test...

 

[aween]

Apache2triad is good! I used it before i got real hosting :P . It can be simple and advanced at the same time.

 

[Albino]

Wow, a lot comes with that!

i am happy with what Ive got at the moment though (apache, mysql, php), as i want to keep it basic and progress to more advanced things.

are there anymore solutions?

Thanks

 

[cerebus]

Did you totally ignore the URL given?

http://dev.mysql.com/doc/mysql/en/old-client.html

It gives instructions on how to use OLD_PASSWORD() to update your user table, making it compatible with the pre 4.1 clients.

 

[Albino]

yea, and i said i tried it, but it didn't seem to work...

I typed in this:

SET PASSWORD
'root'@'localhost' = OLD_PASSWORD('compaq')

is it wrong?

 

[Peter]

php 4.3.3 (im using 4.3.11 as I could find 4.3.3)

just a note the reason you couldnt find 4.3.3 is because it is outdated 4.3.11 is the newest version of php 4 (i know it sounds stupid but thats the way the versions work)

 

[Albino]

ahhh, cheers filth
Ok, its all sorted now, after looking around the mysql site, i figured out the syntax

Thanks for the help everyone one!

Todd