mySql 5

ianraba
Posts: 34
Joined: 2010-06-24 17:44

mySql 5

Post by ianraba » 2010-11-21 13:53

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

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: mySql 5

Post by Fred » 2010-11-22 10:58

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
Posts: 34
Joined: 2010-06-24 17:44

Re: mySql 5

Post by ianraba » 2010-11-22 16:59

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?

User avatar
Fred
Site Admin
Posts: 491
Joined: 2010-02-15 12:10
Location: Armagh, Northern Ireland
Contact:

Re: mySql 5

Post by Fred » 2010-11-23 09:34

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
Posts: 35
Joined: 2010-07-09 16:17

Re: mySql 5

Post by jlig » 2013-01-10 23:58

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..

Post Reply