Help Please

[obrienkev]

Hi all,

I'm trying to enter data via a html form into mysql database. (using php4)

However when I press submit I get this error:

Could not connect: Client does not support authentication protocol requested by server; consider upgrading MySQL client

What does this mean? How can I solve this problem.

Thanks very much.

Kevin.

[RossC0]

It means you cannot connect to your MySql database via php.

Check your settings - username & password.

What version of mysql you running ?
You may have to set up the database to use the old password hash for php to access it...

[obrienkev]

I'm using the latest version of mysql - 4.1

Tried setting password and username but it wo't work.

Any ideas?

Thanks.

Kevin.

[RossC0]

Hi,

Yeah 4.1 sets passwords using a new hash - and php4 uses the old hash.

Try this:
Old_Password()

Run a query to reset the username & password:

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Mysql Website: MySql Password Hashing

[obrienkev]

I tried doing that on command line but get this error:

" 'mysql is not recognisable as an internal or external command..."

Then I tried installing version 4 but I can't find any install package once I downloaded??

thanks for your help.

Kevin.

[RossC0]

OK - thats a command line query for running queries from the mysql command line.

Do you have mysql query browser set up ?

If so use these queries:

UPDATE mysql.user SET Password = OLD_PASSWORD('password')
WHERE Host = 'localhost' AND User = 'username';

Then run:
FLUSH PRIVILEGES;

To reset the privileges in mysql and vola!

[obrienkev]

can't seem to get mysql command working -- just get error messages.

How do I set up the query browser?

Thanks.

[RossC0]

Here:
Query Browser

Also get:
Administrator