Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorahawks
    • CommentTimeDec 17th 2007 edited
     
    Trying to run the _install.php script. Hosting on GoDaddy.com (Windows server). MySQL 4.1.
    I have the proper host name, username, password, and database name, but I get the following errors:

    * Cannot connect to MySQL with the information provided. MySQL error: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    * Couldn't find the database ajhawks_plogger. MySQL error: Can't connect to MySQL server on 'localhost' (10061)

    Note: the database is NOT on 'localhost', but on a different server within GoDaddy (for security, not posting the actual host).

    First, what can I do about the authentication protocol error?
    Second, Why does plogger default back to localhost? I grepped the folder for 'localhost' and found a default value in lib/plogger/install_functions.php and changed it to the proper host as a test, but it still shows up as localhost.
    • CommentAuthorahawks
    • CommentTimeDec 17th 2007
     
    Just a follow up with some more info I've found.
    According to the MySQL 5.0 manual, http://dev.mysql.com/doc/refman/5.0/en/old-client.html , the "Client does not support authentication protocol requested by server" message is because MySQL 4.1.1 and above use a different PASSWORD() encryption technique, so any old mysql libs will fail when they try to use the outdated PASSWORD() call.

    Apparently, the solution is to either update your libmysql.dll / .so, or update the mysql.user table:
    update mysql.user set password=OLD_PASSWORD('password') where user='your username';