From:       To:      
Home > Documentation > MySQL

How to fix the error "The program does not support authentication protocol requested by server..."

MySQL 4.1.0 uses the authentication protocol based on a password hashing algorithm that is incompatible with that used by Intelligent Converters software. Use OLD_PASSWORD function to make the certain account compatible with the modetrn password hashing algorithm. Login to MySQL server with administrator privileges and run the following queries:

    mysql> USE mysql;
    mysql> UPDATE user SET Password = OLD_PASSWORD('some_pass')
        -> WHERE Host = 'some_host' AND User = 'some_user';
    mysql> FLUSH PRIVILEGES;

Of course, you should place actual values instead of 'some_pass', 'some_host' and 'some_user'. Now you can use 'some_user' account with Intelligent Converters software.

Have more questions? Contact us

See also

Useful MySQL Queries
Tuning MySQL Performance
How to Backup and Restore MySQL Database