How to install/configure MySQL Database
MySQL is a relational database management system. It is a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL is open source software. It is provided by MySQL AB, a Swedish company owned and run by the MySQL founders and main developers.
Since the core of the Magda-Manager for Grid-based Data is a MySQL database (the principal entities of Magda are implemented as MySQL tables), we wanted to install MySQL first to better understand its functionality and features. Requirements: MySQL needs at least Linux kernel versions 2.0 or higher. Where to learn more: The MySQL home page, http://www.mysql.com, provides the latest information about MySQL. The most recent version of the MySQL reference manual is available at http://www.mysql.com/documentation/index.html
How to download/install MySQL database:
1. Go to the page http://www.mysql.com to see which platforms are supported and to decide which version and type of distribution to use. I describe here how to install MySQL 3.23 (stable release, recommended) on Linux.
2. Go to downloads and Linux downloads links. The recommended way to install
MySQL on Linux is by using an RPM (RetHat Package Manager) file. Download both Server and Client programs rpm files. They will appear in your local directory as
MySQL-3.23.43-1.i386.rpm
MySQL-client-3.23.43-1.i386.rpm
3. • To see all the files in an RPM package, run: shell> rpm –qpl MySQL-3.23.43-1.i386.rpm
• To perform the installation, run (as root): shell> rpm –i MySQL-3.23.43-1.i386.rpm MySQL-client-3.23.43-1.i386.rpm
4. The RPM places data in ‘/var/lib/mysql’. The RPM also creates the appropriate entries in ‘/etc/rc.d’ to start the server automatically at boot time.

Leave a Reply
You must be logged in to post a comment.