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

"Could not connect to mySQL server: Client does not support authentication protocol request consider upgrading MySQL client"

mysql
update mysql.user set password=OLD_PASSWORD('pass')
where User='user1';
Query OK, 0 rows affected (0.06 sec)Rows matched: 1 Changed: 0 Warnings: 0

This will solve this problem..
Detail about cause of this problem :
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

php web program

After one week hardworking.. I finish one php program which host in apache webserver and use mysql as database. lot of problem face expecially with this php and mysql
Problem in mysql.. can't connect to mysql server using php.
Problem in php. how to design a page to let use keying data, edit data, and how to let user search existing form.

I read book (The definative guide to mysqsl second edition) , search internet(http://php.resourceindex.com/) and ask friends (thanks boon kit for help in mysql and kim fee in php) , and finally finish the draft

Show my brother and his friend and they request some change.

Next step
1. learn about mysql security
2. Put php code in object instead all in a php form.

New setup mysql server

mysql learning process
1. download mysql database and program from http://dev.mysql.com/downloads/
mysql 5.0 -- mysql database
MySQL Administrator -- Administer MySQL Server
MySQL Query Browser -- Use this graphical client to work with your MySQL databases and run queries

install mysql 5.0
install mysql adminstrator
install query browser

mysql services start
from command prompt
\mysql\mysql server 5.0\bin type mysql
message "ERROR 1045 (28000):Access denied for use 'ODBC'@localhost'

how to solve?
1. from windows->control->panel>services->mysql->stop service
2. from \mysql\mysql server 5.0\bin\mysqld --skip-grant-table
3. open another command prompt \from \mysql\mysl server 5.0\bin type mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
4. change password
mysql> update mysql.user set password=PASSWORD('yourpassword')
-> where User='root';
Query OK, 0 rows affected (0.06 sec)
Rows matched: 1 Changed: 0 Warnings: 0

mysql>
5. type quit to quit from mysql
6. shut down mysql
a) keying mysqladmin -p shutdown
b) Enter password :
c) wait for while. go to command prompt where mysqld --skip-grant-table.
d) The screen will go to command prompt
7) goto windows->control->panel>services->mysql->start service
8) your can login into mysql server with
a) mysql Query Browser

b) mysql administrator
c) from command prompt\mysql\mysql server 5.0\bin\mysql -uroot -p and keying password after system request to.
you should see
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>