Chapter 12. Installing MySQL

Before jumping into MySQL installation you need to get the software. MySQL's database server can be downloaded from MySQL's web site at www.mysql.com. As of this writing, the free Community Edition server feels somewhat hidden on the web site. Therefore, with the caveat that the URL may change on a whim by the time you read this text, the download section for MySQL is currently located at http://dev.mysql.com/downloads. However, realize that most distributions of Linux include their own MySQL server package.

Obtaining MySQL

I strongly recommend using the MySQL server package directly from your Linux distribution rather than downloading from MySQL AB unless you have a very specific reason for using a different version. If you can't think what one of those specific reasons might be, then you probably don't have one, and you therefore should use the MySQL server available with your distribution.

Installing MySQL on Linux

There are several distributions upon which you might find yourself installing MySQL. It's always a challenge choosing which distributions to cover. No matter which ones we decide to cover there will always be someone installing on another distribution.

In this section I'll examine MySQL installation on Debian, CentOS, and Ubuntu. Additionally, I'll demonstrate compiling MySQL from source for those who don't have a MySQL server package available with their distribution. ...

Get PHP6 and MySQL® 6 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.