Even for DBAs already familiar with MySQL, the choice of installation methods and the variety of install\/package files is overwhelming and confusing.<\/p>\n
I’ll make a (very!) brief introduction to the various installation options, concentrating on the Linux operating system, and provide with a simple shopping list.<\/p>\n
For illustration, I’ll refer to the MySQL 5.1.52<\/strong> community edition, the latest at the time of this writing. Downloads are available at http:\/\/dev.mysql.com\/downloads\/mysql\/5.1.html<\/a>.<\/p>\n I will then refer to alternate distributions.<\/p>\n You are lucky: your choice is very clear. Download the Windows MSI package. Choose 32<\/strong> or 64<\/strong> bit architecture according to your OS. If you know about the other ways to install and setup MySQL under Windows, you don’t need this post.<\/p>\n Easiest way to install MySQL on linux would be to use your distro’s repository. Just:<\/p>\n or<\/p>\n Your distro should resolve any package dependencies.<\/p>\n I’m in the opinion that if MySQL is the main application to be used on a server, distribution’s default repositories are not<\/em> the way to go. Reasons include MySQL outdated version, incapability of installing multiple instance, danger of automatic upgrades or downgrades. Read this post and discussion<\/a> that follows for more.<\/p>\n If you’re a RedHat\/CentOS\/SuSE user, you’re in luck: MySQL provides pre-built RPM packages for your system. I vaguely remember MySQL announcing that Ubuntu is to be supported. That was a couple years ago; there is still no package for Debian\/Ubuntu.<\/p>\n So, assuming you’re a RedHat\/CentOs user, which packages should you download?<\/p>\n There’s over 60<\/strong> different RPMs available for download. I always need to stress my eyes to get it right. Here’s the simple answer (again, if you know better, you don’t need this post). Choose “RedHat & Oracle Enterprise Linux”<\/strong>; download:<\/p>\n The above assumes a RedHat\/CentOS 5.x and a 64 bit Intel\/AMD processor.<\/p>\n The aforementioned post relays my opinion of using RPMs; these are still susceptible to yum<\/strong>‘s whims. Be careful.<\/p>\n Not afraid to install by hand? Want to avoid limitations introduced by pre-built packages? Download a binary distribution:<\/p>\n This tar.gz<\/em> distribution includes server & client. It includes glibc<\/em> so it does not depend on your OS installed glibc<\/em> version (a pain to upgrade\/downgrade as it is used by so many packages).<\/p>\n You may still want to download and install the shared-compat<\/em> RPM package (see previous section) to have all possible libmysqlclientX.X packages installed.<\/p>\n If you got here, then you either know your way around (why do you keep reading?) or you have a good reason to use a source distribution.<\/p>\n What good reason could that be?<\/p>\n A more and more common reason is that you want to add something to MySQL. Sphinx search storage engine is such a common addition.<\/p>\n You don’t have to download the official MySQL distribution. Two good alternatives are:<\/p>\n Even for DBAs already familiar with MySQL, the choice of installation methods and the variety of install\/package files is overwhelming and confusing. I’ll make a (very!) brief introduction to the various installation options, concentrating on the Linux operating system, and provide with a simple shopping list. For illustration, I’ll refer to the MySQL 5.1.52 community […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[10],"class_list":["post-3089","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-installation"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-NP","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/3089","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=3089"}],"version-history":[{"count":10,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/3089\/revisions"}],"predecessor-version":[{"id":3099,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/3089\/revisions\/3099"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=3089"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=3089"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=3089"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}A note for Windows users<\/h4>\n
Linux: repositories<\/h4>\n
\n
sudo apt-get install mysql-server-5.1<\/pre>\n<\/blockquote>\n
\n
sudo yum install MySQL-Server-5.1<\/pre>\n<\/blockquote>\n
Linux: packages<\/h4>\n
\n
Linux: binary<\/h4>\n
\n
Linux: source<\/h4>\n
\n
Non MySQL downloads<\/h4>\n
\n