mysql 5.1 tweak needed in plesk update - flush privileges

[105547111]

On one of my servers the upgrade to plesk 9.2.1 failed. It was because in mysql 5.1 they changed one of the queries:

Trying to check psa database... Trying to find psa database... version is 0901

ERROR while trying to execute SQL query, the query was: DELETE FROM mysql.user WHERE user = ''; FLUSH PRIVILEGES;
Check the error reason(see log file: /tmp/psa_9.2.1_fc8.build92090422.13_upgrade.090429.08.45.log), fix and try again

Aborting...

I got around the issue and its working well. However Parallels you need to update your query to be current with mysql.

 

[Geoff Winans]

I got around the issue and its working well. However Parallels you need to update your query to be current with mysql.

You shouldn't be running a version of MySQL that isn't explicitly supported by PLESK.

Also, 5.1 is so far away from production-ready. Do yourself a favor and roll back to 5.0.x

 

[105547111]

5.1 is stable and production ready, check the sql site.

Fedora 11 rolls out in under two weeks with 5.1.34!

 

[atomicturtle]

Here is the open bug list for 5.1.34:

http://dev.mysql.com/doc/refman/5.1/en/open-bugs.html

 

[105547111]

I don't debate there are bugs, but the statement 'far away from production use' is just wrong!

 

[Geoff Winans]

The original developer of MySQL will heartily disagree that 5.1.x is ready for a GA Release.

5.1 has NUMEROUS show-stopper bugs.

5.1 is stable and production ready according to Sun. Not according to the guy that originally created it (who has since left Sun).

Wish I could find the article he wrote up about it - he tore Sun a new one.

EDIT:

KNOWN Showstopper Bugs == Not Ready For Release

 

[atomicturtle]

I think its this one:

http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html