phpMyAdmin 2.5.4 login in ERROR!

phpMyAdmin 2.5.4 + MySQL 4.17 + PHP 5 When the weclome picture is being shown, i try to login with root ,but error message is occurred. That is as follow: #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client Thanks for all and need your

select from two tables then create a new table

Hi all: There is a question: Two tables: table_out: ( fields ) product_name,out_count , out_date table_in: ( fields ) product_name,in_count , in_date I want to create a table that show the remain of product. Can you help me?? thanks in advance! -- MySQL