Home > MySQL Installation & Configuration > MySql Installation & Configuration

MySql Installation & Configuration

 

 

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:

There are three installation packages to choose from, when installing MySQL (Windows):

  • Windows Essentials: This package has a file name similar to mysql-essential-5.1.39-win32.msi and contains theminimum set of files needed to install MySQL on Windows, including the Configuration Wizard. This package does not include optional components such as the embedded server and benchmark suite.
  • Windows MSI Installer: This package has a file name similar to mysql-5.1.39-win32.zip and contains all files needed for acomplete Windows installation, including the Configuration Wizard. This package includes optional components such as the embedded server and benchmark suite.
  • Without installer: This package has a file name similar to mysql-noinstall-5.1.39-win32.zip and contains all thefiles found in the Complete install package, with the exception of the Configuration Wizard. This package does not include an automated installer, and must be manually installed and configured.

Generally, you should use the Windows MSI Installer. It is simpler to use than the others, and you need no additional tools to get MySQL up and running. The installer for the Windows version of MySQL, combined with a GUI Configuration Wizard, automatically installs MySQL, creates an option file, starts the server, and secures the default user accounts.

1. Browse to the MySQL download site: http://dev.mysql.com/downloads

2. Select the “MySQL 5.1—Generally Available (GA) release for production use” link under MySQL Community Server.

3. Click the download button under the MySQL Community Server.

4. Locate and select your appropriate platform. In our case, we click on Windows, and select the Windows MSI Installer.

5. Click on “pick a mirror”, on the next displayed page you can avoid the registration and just click the “» No thanks, just take me to the downloads!” link.

6. Chose a mirror close to you. Download and save Windows MSI Installer (mysql-5.1.39-win32.msi) to a convinient location on your computer.

 

 

Installation Instructions:

The MySQL Installation Wizard, in combination with the MySQL Configuration Wizard, allows a user to install and configure a MySQL server that is ready for use immediately after installation. MySQL Server Setup wizard guides you through the MySQL installation, followed by the Configuration wizard.

1. Browse to where you downloaded MySQL, and double-click the installer file(mysql-5.1.39-win32.msi).

2. At the Welcome window, click Next.

3. Select the Typical setup type, and click Next.

4. Click Install. Once the install is complete, click Next on the window. Again another Next.

5. Unselect the MySQL registration option “Register the MySQL server now”.

6. Click Finish (Make sure that “Configure the MySQL server now” is selected).

7. For MySQL 5.1 on Windows, the default installation directory is C:\Program Files\MySQL\MySQL Server 5.1. Once installation is complete, MySQL installation folder will include the following directory structure:

Directory Contents of Directory
bin Client programs and the mysqld server
data Log files, databases
Docs Manual in CHM format
examples Example programs and scripts
include Include (header) files
lib Libraries
scripts Utility scripts
share Error message files

 

8. The MySQL Server Setup wizard closes, and the MySQL Server Instance Configuration wizard opens.

 

 

Configuration Instructions:

The MySQL configuration wizard starts immediately after the MySQL Server Setup wizard closes. This section describes how to configure MySQL.

1. In the Welcome window, click Next.

2. Select Standard Configuration, click Next.

3. Select Install as Windows Service and Include Bin Directory in Windows PATH, and click Next.

4. Set the following security options:

  • Select Modify Security Settings.
  • Type the root password admin, and then retype the password.

5. Click Next.

6. Click Execute. A message informs you the configuration is complete and MySQL is installed (“Configuration file created. Windows service MySql installed. Service started successfully. Security settings applied.”).

7. Click Finish.

Note: If there are problems while performing the installation steps above, you will need to perform certain troubleshooting steps with the installation. This will be available in a different post shortly.

 

 

Verify MySQL installation:

By now, MySQL set up is complete and you can verify that MySQL is correctly installed.

1. Open MySQL Command Line Client from Start Menu.

2. Type the password that you set during the installation, and press ENTER.

3. At the mysql> prompt, type exit to exit MySQL.

Information about the installed MySQL version displays. If no errors are reported, MySQL is installed and running.

 

 

Follow the video tutorial for download, install and configuration instructions:


 

Vodpod videos no longer available.

 

 

 

Links:

http://www.mysql.com/

 

  

Note: Refer to other posts in MySQL catergory for further knowledge.

 

 

Advertisements
  1. Java for beginners tutorials
    December 4, 2010 at 11:02 pm

    Mysql is the data base which is used by all word press sites and even many are using Mysql but to learn how to install and start thisi the right place to know.

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: