hmmm,
I read about this topic elsewhere, and it was dated 2009 (I think(yes))
This topic is dated 2010. (yes, latish)
First and for all, this is mysql's fault, for constantly breaking compatibility.
We can't simply say "all mysql 5.x versions are compatible" in advance, we actually have to wait till a point release is out, sufficiently tested, and then we can also allow the sqlconnection of "5" to load "5.1". Since it might as well be not compatible at all.
The smartest way to avoid this nonsense is to
(1) avoid mysql if you can.
(2) be reluctant with upgrading without a very good reason.
And NOW, we are soon mid 2011, and I'm on .9.30...
And still mySQL 5.1.x is NOT working with Lazarus?
This thread started in July 2010. Free Pascal 2.4.2 went into freeze in May 2010, and while the 5.1 problem was known very shortly before this happened, it was deemed too intrusive to merge the last minute.
FPC 2.4.4 will have it, and building for it has started. (will take a few weeks), and I assume lazarus will follow suite shortly after.
should I be concerned, or is this to be expected by an "up to date" software!
Your anger is directed in the wrong direction. MySql keeps the situation confused deliberately to sell their commercial product.
The free version is essentially unsupportable, and can be considered crippleware.