Openfire is still shipping with the older MySQL JDBC driver (5.0.8), while the latest driver available from MySQL page is 5.1.26. Older driver has issues with the newest MySQL (Users list is not showing in the Admin Console, maybe other issues or performance bugs). New driver should be backwards compatible, but some testing should be done.
MySQL 5.6.10 - works fine (newest versions don't work, because the have no SET OPTION support anymore)
MySQL 5.1.x - Jason will test this, no bad reports, assuming that works fine
MySQL 5.0.x - Jorge reports - works fine
HSQL (Embedded database) - has its own driver, so not affected
Check for yourself. Download this jar, rename it to mysql.jar, backup older mysql.jar in openfire\lib\, stop Openfire, copy new jar on top of the old one, start Openfire and check if it works. Report back, as nobody yet reported is it working with 5.0.x MySQL.
FYI, updated the MySQL client to 5.1.30 for the upcoming Openfire 3.9.2 release.
tried driver 5.1.28 with mysql 5.0.96 and so far so good.
As there are no further issue reports and users report it is working with various MySQL versions, closing this ticket for now (new reports or comments should be directed to the forums).