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?