Page 1 of 1
mySql 5
Posted: 2010-11-21 13:53
by 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
Re: mySql 5
Posted: 2010-11-22 10:58
by 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.
Re: mySql 5
Posted: 2010-11-22 16:59
by 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?
Re: mySql 5
Posted: 2010-11-23 09:34
by 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.
Re: mySql 5
Posted: 2013-01-10 23:58
by 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..