Problem:

You are trying to connect to your MySQL database server version 4.1 or higher with Pronto Survey Analyzer to retrieve survey results, but you're receiving an error message

MySQL connection failed: verify that the server parameters are correct 

and all the MySQL settings are OK.

How to solve:

Starting version 1.1, you can connect to the database thru the HTTP protocolor and the analyzer.php script provided with the survey, avoiding this problem.

However, if you don't want to connect thru HTTP, and would like a direct connection to the MySQL server, please continue to read.

This problem is related in fault on Pronto Survey Analyzer, because the MySQL library used to build the software, is not connecting properly with MySQL servers versions 4.1 and up.

MySQL changed the authentication scheme from version 4.1.

To deal with this problem, you can change a password in a special way. For example, normally you use SET PASSWORD as follows to change an account password:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = PASSWORD('mypass');

To change the password, use the OLD_PASSWORD() function instead:

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

and remember that everytime you change a password or user access privivileges, you must issue a:

mysql> FLUSH PRIVILEGES;

For more information, please take a look at the following links in MySQL.com

http://dev.mysql.com/doc/mysql/en/password-hashing.html
http://dev.mysql.com/doc/mysql/en/application-password-use.html

A future version of Pronto Survey (we hope it's very soon, but we depend on our compiler vendor) will fix this issue, however, you can use the HTTP connection, as stated at the beginning of this article, to overcome this limitation.