mySql 5

[ianraba]

Anyone migrated to mysql 5?
Any issues?
I have (we all have) a situation where mysql4 is no longer supported by cPanel and as cPanel is the most used admin interface for hosting accounts this represents a force majore

Any advice/tips welcome

Thanks

[Fred]

Been running on Mysql 5 for a while now.
The only problems I had with the upgrade was the length of the usernames.
Only 7 characters is allowed.

Can't think of anything else.

[ianraba]

Sorry fred, Usernames?
in MX login? so i can no longer use an email address and any sites using email address as a username will no longer allow access?

[Fred]

no no the username to the mysql db itself.
The email address for MX login is just another bit of data stored in the db and irrelevant to what can or cant be done.

[jlig]

MySQL 5.5 works with ADDT & ColdFusion 9.. except that my Date Fields had issues..

Fix: Is to insert the following code into the database connection String in the CF Datasources page: zeroDateTimeBehavior=convertToNull

Note: To get the Wizards to work in DW CS4 you also have to adjust the ADDT includes files.. see other link in this forum..