Archive for the ‘SugarCRM’ Category

SugarCRM MySQL Error

2007-11-10

While installing SugarCRM on Windows XP, got error message [Client does not support authentication protocol]. To resolve this issue had to do the following commands in MySQL Query Browser.
1) UPDATE mysql.user SET Password = OLD_PASSWORD(‘password’) WHERE Host = ‘localhost’
AND User = ‘root’
2) FLUSH PRIVILEGES;

reference:

http://www.sugarcrm.com/forums/showthread.php?t=21140&highlight=upgrading+MySQL+client

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

MySQL, SugarCRM, Windows No Comments