Section: II. C. 1

Step 1: Go to MySQL download site

URL to download MySQL Database:
In order to download the MySQL database, go to the URL:http://www.mysql.com/downloads/index.html

Step 2: Download the MySQL database

Which files to download:
In that page, under the heading 'MySQL Database' you need to download the latest stable version of MySQL. Click on that version ( say MySQL 5.0) and you will be led to a page 'Downloads for the 5.0 version'. On that page under the heading 'Standard binary RPMs', you need to download 4 files, namely:

• The server for i386 systems
• Client programs for i386 systems
• Include files and libraries for development for i386 systems
• Client shared libraries for i386 systems

Step 3: Install MySQL

Next, you need to install MySQL in your server.

To install MySQL there, you need to type in the following commands:

shell> rpm -i MySQL -VERSION.i386 shell> rpm MySQL -client -VERSION.i386.rpm shell> rpm MySQL -devel -VERSION.i386.rpm shell> rpm MySQL -shared -VERSION.i386.rpm

Step 4: Initialize the database

Now you need to change your directory to 'module'. There you need to launch the following script to initialize your database:

shell> /usr/bin/mysql_install_db

Next, change the root password:

shell> /usr/bin/mysqladmin -u root password 'mypassword'

Always remember to put your password in this case inside single quotation marks.


Step 5: Create the Database

The next step would be to create a database. In order to do so, you first need to connect to the database using the following commands:

shell> mysql -u root -p password (enter your database password here) mysql> create database <database_name>; mysql> use <database_name>

Then copy and paste the tables provided in the file default_database_tables.htm.
The tables will be created and now your MySQL database is completely installed.

Step 6: Create a user

Now you need to create an user with limited rights in the database for WeMessage to connect. In order to do so, type in the following command:

shell> GRANT select, insert, delete, update on <database_name>.* TO <username>@localhost IDENTIFIED BY <password>;

where database_name is the name of the database that you created in Step 5, username and password are assigned by you.

Note: This document is being written when the current MySQL stable release is MySQL 5.0. So it is always advisable to check out the MySQL website for the latest information on installation and usage of the MySQL Database server. The URL to do so is:

http://www.mysql.com/documentation/index.html