MySQL Authentication errror 1251 on Solaris.

I am trying to connect to MySQL installed on windows from Solaris machine.

While doing this getting error as:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client; errno = 1251"

I have installed mysql-5.1.34-solaris10-sparc.tar.gz on Solaris.

mysql_real_connect() gets failed. If I do the same from mysql prompt it is succesfully connect to mysql on windows.

-bash-3.00# ./mysql -u root -h 10.77.176.122 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 5.1.34-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

But when I do following I get error.

-bash-3.00# ./mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
-bash-3.00# ./mysql -uroot -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
-bash-3.00#

Can you please tell us what needs to be done for this?

Hia,

Maybe teh belo wlink can help.

MySQL Lists: mysql: RE: MySQL Error 1251 / phpMyAdmin

Cheers,
Shazin