does not support authentication

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
navid
Forum Commoner
Posts: 68
Joined: Tue Sep 24, 2002 3:14 am
Location: iran

does not support authentication

Post by navid »

hi
i'm install mysql 4 on win 2003 server
i can't connect to mysql with php script
but i can connect with mysql prommpt.
i'm sure the password is currect.

i checked my open port on server
the 3306 port is open.

i get htis error when irun the script
"Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in "
please, help me
thanks
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

if you are using MySQL 4.1+, it requires the new MySQLi extension.
navid
Forum Commoner
Posts: 68
Joined: Tue Sep 24, 2002 3:14 am
Location: iran

Post by navid »

i will install mysql-4.1.10 .
please help me
thanks
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

help you what? I told you what the problem is.
navid
Forum Commoner
Posts: 68
Joined: Tue Sep 24, 2002 3:14 am
Location: iran

Post by navid »

hi
please help me to
How install mysqli extention on server?
where i downlode it?

thanks
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

look through your php.ini you should see a commented out mysqli extension in there somewhere.
navid
Forum Commoner
Posts: 68
Joined: Tue Sep 24, 2002 3:14 am
Location: iran

Post by navid »

i'm looking for mysqli in php.ini
but can't find it
navid
Forum Commoner
Posts: 68
Joined: Tue Sep 24, 2002 3:14 am
Location: iran

Post by navid »

hi
i think mysql is just for php5
i'm install php4-3-10

is it right?
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

MySQL goes right back to PHP3.

If the extension is not listed in php.ini.

Download it and put it in the php extension directory.

Then add a
extension=php_mysqli.dll
To the list of extensions in php.ini.

Not sure if that's the actual problem though. I've had that error message in my setup before. It was just on one particular account - one I created with phpMyAdmin. I deleted the account and set it up manually from the command line and it worked after that.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

we've discussed this problem before.....

http://dev.mysql.com/doc/mysql/en/old-client.html
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post by d3ad1ysp0rk »

I don't think the problem is as much a technical one as a language barrier.
Post Reply