Mysql Error

Albino · 06-15-2005, 11:08 AM

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 · 06-15-2005, 11:34 AM

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 · 06-15-2005, 11:37 AM

Originally Posted by 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

????: NamePros.com http://www.namepros.com/programming/98860-mysql-error.html

Albino · 06-15-2005, 12:04 PM

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 · 06-15-2005, 12:10 PM

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 · 06-15-2005, 01:05 PM

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

go apache2triad !!!!

axilant · 06-15-2005, 01:09 PM

Originally Posted by edmarriner

no get apache2triad ( http://apache2triad.net/ )
????: NamePros.com http://www.namepros.com/showthread.php?t=98860

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

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 · 06-15-2005, 01:53 PM

Apache2triad is good! I used it before i got real hosting

. It can be simple and advanced at the same time.

Albino · 06-15-2005, 02:59 PM

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 · 06-15-2005, 04:20 PM

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 · 06-15-2005, 11:42 PM

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 · 06-16-2005, 12:56 AM

Originally Posted by Albino

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 · 06-17-2005, 04:03 AM

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

06-15-2005, 11:08 AM	THREAD STARTER #1 (permalink)
Albino Munky Designs Join Date: May 2005 Posts: 996	Mysql Error 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

06-15-2005, 01:05 PM	#6 (permalink)
edmarriner NamePros Regular Join Date: Apr 2005 Location: England :D Posts: 834	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 go apache2triad !!!! __________________ Leeds united football club Leeds United , news , rumors , wallpapers and more!

06-15-2005, 01:53 PM	#8 (permalink)
aween Pro Coder & Designer Join Date: Apr 2005 Location: Netherlands Posts: 967	Apache2triad is good! I used it before i got real hosting . It can be simple and advanced at the same time. __________________ aween web development

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
HOWTO: Install the Apache Web Server, Perl, PHP, and MySQL on Windows	deadserious	Webmaster Tutorials	96	05-27-2007 01:24 PM
Tutorial: How to Install Apache2 MySQL and PHP on Windows	deadserious	Webmaster Tutorials	35	09-21-2005 09:46 PM
mysql error? help... please! lol	PoorDoggie	Programming	6	04-04-2005 11:53 AM
Tutorial: Getting Started With MySQL (The Basics)	deadserious	Webmaster Tutorials	3	04-18-2004 01:17 PM

06-15-2005, 11:34 AM	#2 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	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

06-15-2005, 12:04 PM	THREAD STARTER #4 (permalink)
Albino Munky Designs Join Date: May 2005 Posts: 996	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

06-15-2005, 12:10 PM	#5 (permalink)
axilant Account Suspended Join Date: May 2004 Location: /etc/passwd Posts: 2,178	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.

06-15-2005, 02:59 PM	THREAD STARTER #9 (permalink)
Albino Munky Designs Join Date: May 2005 Posts: 996	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

06-15-2005, 04:20 PM	#10 (permalink)
cerebus NamePros Regular Join Date: Oct 2003 Location: Sweden Posts: 395	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.

06-15-2005, 11:42 PM	THREAD STARTER #11 (permalink)
Albino Munky Designs Join Date: May 2005 Posts: 996	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?

06-17-2005, 04:03 AM	THREAD STARTER #13 (permalink)
Albino Munky Designs Join Date: May 2005 Posts: 996	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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)