MySQL+Installation

__** Installing MySQL on OpenSuSE 11.4: **__


 * 1. Installing from source ** – is highly recommended but takes some time and effort. However, it will get the most recent MySQL installed in a single location on the system, and everything will be configured according to our needs.

This involves downloading MySQL Community Server from the official MySQL page and choosing the latest tarball file under the Linux Generic menu.

The only major problem we came across with this method is that many users complain about problems and errors with completing the installation of MySQL which involves the creation of a configuration file named (my.cnf) from 4 pre-made configuration files (*.cnf) in the support directories. These files offer several security and control options (e.g) limiting system resources used by MySQL.


 * 2. Using YaST **– is the easiest and fastest way to install MySQL. However, the version of MySQL bundled with the SuSE installation is usually NOT the most recent.

This method was out of the question at the beginning as we were told by Prof. Hotop that using an Internet connection on OpenSuSE server was not encouraged, but we have opted for this method because it will be the only way for us to have a problem-free installation.

One additional note regarding this method is that most of the How-Tos we found online install MySQL as part of a bundle named LAMP (Linux Apache MySQL PHP). The recommended order for installation is MySQL first followed by Apache then PHP.

Here is a useful how-to on installing LAMP: http://www.howtoforge.com/installing-apache2-with-php5-and-mysql-support-on-opensuse-11.4-lamp

Installation of MySQL using YaST will take place on Saturday 9th April at 14:00

Note: Apache and PHP are not needed and wont be installed, only the instructions for MySQL installation were used.