Archive

Archive for the ‘MySQL Installation & Configuration’ Category

MySql Installation & Configuration

September 1, 2009 1 comment

 

 

At the time of this post, the current release is MySQL 5.1 – Generally Available (GA) release for production use and is the recommended version, though MySQL 5.4 is available to download as Beta release. When preparing to use MySQL, you should decide the version to go ahead with. After deciding which version to install, you can choose a distribution format. Releases are available in binary or source format.

The first decision to make is whether you want to use a production (stable) release or a development release.

  • MySQL 5.4 is the current development release series.
  • MySQL 5.1 is the current General Availability (Production) release series. New releases are issued for bugfixes only; no new features are being added that could affect stability.
  • MySQL 5.0 is the previous stable (production-quality) release series.
  • MySQL 4.1, 4.0, and 3.23 are old stable (production-quality) release series. MySQL 4.1 is now at the end of the product lifecycle. Active development and support for these versions has ended.

If you are beginning to use MySQL for the first time or trying to port it to some system for which there is no binary distribution, go with the General Availability release series. Currently, this is MySQL 5.1.

After choosing which version of MySQL to install, you should decide whether to use a binary distribution, or a source distribution. In most cases, you should probably use a binary distribution.

Binary distributions contain a setup program that installs everything you need so that you can start the server im-mediately. Another binary distribution format contains an archive that you simply unpack in the installation location and then con-figure yourself. The source distribution contains all the code and support files for building the executables using the Visual Studio compiler system.

New MySQL users can use the Binary distributions (which contains the MySQL Installation Wizard and MySQL Configuration Wizard) to install MySQL. These are designed to install and configure MySQL in such a way that new users can immediately get started using MySQL.

 

 

Pre-Requisites:

Please note that not all platforms are equally suitable for running MySQL, and that not all platforms on which MySQL is known to run are officially supported by Sun Microsystems, Inc. AIX 4.x / 5.x, FreeBSD 5.x, HP-UX 11.x, Linux, Mac OS X, Solaris 2.8, Windows 2000, Windows XP, Windows Vista, Windows Server 2003, and Windows Server 2008 are the platforms supported.

 

  

Download Instructions: Read more…