I happened across this article on BSDHound.com about setting up MySQL. While the author does a reasonable job handling the security aspects of MySQL, he makes two mistakes that I think need to be corrected.


  1. Suggests that people use MySQL 3.23. While that's a stable and mature version, I suspect that most folks are best served by using 4.0.xx instead. There are many improvements in the 4.0.xx series and many bugs fixed as well.
  2. He doesn't tell readers about building it with LinuxThreads support and the advantages of doing so.

I'm really surprised at home many FreeBSD/MySQL folks still don't use LinuxThreads. Someday we should be getting official MySQL binaries with LT support from MySQL.com too. I need to bug Lenz about that again...

Posted by jzawodn at November 30, 2003 10:44 PM

Reader Comments
# Larry said:

Well, "bad" and "mysql (advice)" are synonymous with one another.

on December 1, 2003 12:53 PM
# ian gilfillan said:

I see he's already changed the article in response to this!

But surely building MySQL with LinuxThreads support will only give an advantage for a multi-CPU machine?

on December 3, 2003 02:26 AM
# tom said:

Is it possible that the http://bsdhound.com/newsread.php?newsid=90 article was an old one?

on December 3, 2003 06:46 AM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.


Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.