View unanswered posts | View active topics It is currently Fri Jul 20, 2018 12:13 am



Reply to topic  [ 3 posts ] 
 MySQl 4.1.7 & PHP 5.0.2 on IIS 5 
Author Message
Junior Member

Joined: Thu Nov 25, 2004 2:30 am
Posts: 4
Post 
Hello all.

I need a little help. I am installing on Win XP Pro, MySQL 4.1.7, PHP 5.0.2, and IIS 5.1 (comes with XP Pro). I can view plain HTML's through my browser but am having trouble with MySQL and PHP5 communicating.

When I execute "<?php phpinfo(); ?>" from my browser, I get the PHP version and info, etc. So I gather that my PHP5 installation is OK.

But when I try to connect to my SQL via PHP5 with:
"<?php $connection = mysql_connect( "localhost", "root", "pass+word" )
or die( "Sorry - unable to connect to MySQL" );
echo( "Congratulations - you connected to MySQL" );"

I get the following error:

" Sorry - unable to connect to MySQLPHP Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\WWW\mysqltest.php on line 11"

What am I doing wrong?

Help, please.........

:( :blink: :unsure:

Thanks in advance.

Tony


Tue Dec 07, 2004 11:46 pm
Report this post
Profile
Junior Member

Joined: Tue Jan 04, 2005 10:50 am
Posts: 17
Post 
You need to make sure the MySQL client DLL libraries on your system. If you downloaded the ZIP files and not the self extractor. There will be a file named libmysql.dll place this in your SYSTEM32 directory.


Fri Jan 07, 2005 2:19 am
Report this post
Profile
Junior Member

Joined: Thu Dec 21, 2006 11:45 pm
Posts: 1
Post you need to run this command after create a new account
Please run this command after you create an account for your MySQL Server:
mysql> SET PASSWORD FOR [email="'USER_NAME_YOU_DEFINE'@'localhost'"]'USER_NAME_YOU_DEFINE'@'localhost'[/email] = OLD_PASSWORD('USER_PASSWORD_YOU_IDENTIFY');

Because the authentication protocol which used by MySQL4.1 and later version does not support the older client.


Thu Dec 21, 2006 11:55 pm
Report this post
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 0 guests


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 post attachments in this forum

Search for:
Jump to:  
cron
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.