mysql 4.1 and my forum

[kahlid123]

after i upgrade mysql to 4.1 my forum not workad i got this error

There seems to have been a problem with the Forums database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience

 

[cooldude7273]

Make sure you have the box checked that says Use old style (4.0) passwords with mySQL 4.1+ in Tweak Settings

 

[tweakservers]

does your forum compatible with the MySQL 4.1 due to the query syntax between MySQL 4.0 and MySQL 4.1 ? there are some major changes on the MySQL 4.0 to MySQL 4.1, do you have a backup copy of your database before it is being upgraded?

 

[celliott]

Open up my.cnf and add the following:

[mysqld]
old-passwords.

I found that the old password feature in cPanel didnt work for me. If there appears to be no connectivity, reset the database password and update your forum configuration file.

 

[kahlid123]

does your forum compatible with the MySQL 4.1 due to the query syntax between MySQL 4.0 and MySQL 4.1 ? there are some major changes on the MySQL 4.0 to MySQL 4.1, do you have a backup copy of your database before it is being upgraded?

do i need to copmile apache wit new mysql?
yes i have back up

 

[kahlid123]

Open up my.cnf and add the following:

[mysqld]
old-passwords.

I found that the old password feature in cPanel didnt work for me. If there appears to be no connectivity, reset the database password and update your forum configuration file.

when i put
[mysqld]
old mysql password

mysql didn't start

 

[kahlid123]

Make sure you have the box checked that says Use old style (4.0) passwords with mySQL 4.1+ in Tweak Settings

yes it is checked

 

[casey]

do i need to copmile apache wit new mysql?
yes i have back up

Yes, you do. It explicitely states that in WHM.