Mysql

[Robbiexxxx]

What mysql version is required to run this program, I get a message suggesting that I upgrade mysql

Rob

[Brian]

Can you post the message?

The calendar itself will not show a message to upgrade mySQL. It only relays messages from the server if there is an error.

[Robbiexxxx]

There was an error connecting to the mySQL database.

The error was reported as:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Mysql works fine with all my other sites, just not this one, as with my original question, does anyone know what version msql is required to run this

[ve9gra]

That's not the issue here... if you read carefully it says that it's the authentication protocol that doesn't work. This usually mean that you've created the password for the account manually without specifying the "old_passwords" option. This encrypts your password in a way that the mysql client that PHP uses can't negotiate.

Follow the instructions posted here to update your password to a version that will be understood by the client you're using. http://dev.mysql.com/doc/refman/5.0/en/old-client.html

[Robbiexxxx]

Sorry I don't understand, are you saying that this calendar is too old to work with the version of mysql ?

[ve9gra]

No.. this has nothing to do with mySQL... There's the mySQL server (the database server) and the mySQL client (like PHP). Newer versions of mySQL (the server) allow for a more secure password version which mySQL (the client) cannot use yet. Most applications do not use the new version of the password. When you created the user for the calendar database, it was created using the new password format. All you need to do to make it work is change the password for that account to use the old password format. Most properly configured hosts will have the old_passwords=1 option set in their mysqld.conf so that this is transparent to the users.

Follow the link I gave you in my previous post.

[Robbiexxxx]

Cheers for the help, i have sorted the problem from your help and have now bought the script

Rob