Connecting ColdFusion 9 to MySQL - memo to self

[janewilliams20]

Also memo to any techy friends or readers, of course, but I doubt if most of you will want to know.

Most web articles will assume you have the DB and CF on the same server, and talk about using 127.0.0.1 rather than localhost. I haven't.

On the DB server, open up port 3306 on the firewall: it's probably blocked. (If it is, you get a timeout error).

Setting up the datasource: use the MySQL (4/5) driver NOT the DataDirect one, unless you've got the paid-for version of MySQL.
Later edit: I'm hearing bad things about the performance of the DataDirect driver even if you do have a version of MySQL it's compatible with.
Edit to add: if that doesn't work either, there's a tech note about downloading a better driver from MySQL. Very clear, and worked for me (at least, my connection validates).

Datasource, go into advanced options, and put this in the "connection string" area:
noDatetimeStringSync=true&zeroDateTimeBehavior=convertToNull
That deals with a problem when a datetime field contains all zeros.

Later edit: check the user you're logging in as in MySQL. They can be tied to IP address, including having root set to just localhost (quite a good idea).


For the rest of you: yes, I'm really enjoying my new job, thanks.

Comments

[eoforyth.livejournal.com]

New job?

[janewilliams20.livejournal.com]

Didn't I post about that, a bit ago? Yes, I finally got something. Direct hire: my CV got spotted on a job site. Initial phone call on a Tuesday lunchtime, interview partway through the afternoon, phone call that evening asking me to start the next day. It was a short-term contract: a week and a half, first time, then renewed for another month, and looks likely to be renewed at the end of this month, too. Pay isn't much, but it's great experience, great fun, and a vast improvement on Job Seekers Allowance. Hard work, though, hence my not posting much lately.

[janewilliams20.livejournal.com]

Yes, thought so. I did post about it.
http://janewilliams20.livejournal.com/205406.html
Maybe you were offline at the time, or something, and it's got lost in the noise.

[eoforyth.livejournal.com]

B says you mentioned it on Facebook, but he forgets I rarely use FB - I'll check that out later :)