MYSQL 4.0 UPDATE HOWTO for sme server v6.x

Author: Ray Mitchell mitchellcpaATyahoo.com.au

Contributing Author: john (jmbaka_AT_yahoo.com)

Date: 13 June 2004 v1

Release for: sme server v6.0, 6.01

UPDATING SME SERVER TO MYSQL 4.0

1. DOWNLOAD MySQL 4.0. FROM WWW.MYSQL.COM

ie from http://dev.mysql.com/downloads/

Save files to a empty folder

MySQL-server-4.0.20-0.i386.rpm

MySQL-client-4.0.20-0.i386.rpm

MySQL-shared-compat-4.0.18-0.i386.rpm

MySQL-devel-4.0.20-0.i386.rpm

Check for the latest stable versions and download those if newer rpms are available

2. STOP MYSQL

/etc/init.d/mysqld stop

3. REMOVE OLD RPM's

rpm -e --nodeps mysql-client mysql-server

You may receive a message saying the mysql-client rpm is not installed, proceed to next.

rpm -e mysql-devel

rpm -e mysqlclient9

4. INSTAL NEW RPMS

The easiest way to instal the four rpms is to have them all in one folder and issue the command

rpm -Uvh *.rpm

(Note the rpm command will instal the rpms in the correct order to allow for dependencies)

5. CONFIGURE

/sbin/chkconfig --levels 2345 mysql on

rm /etc/rc.d/rc7.d/S90mysqld

ln -s /etc/rc.d/init.d/mysql /etc/rc.d/rc7.d/S90mysqld

To enable remote access do

/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no

/sbin/e-smith/expand-template /etc/my.cnf

then

/etc/rc.d/init.d/mysql restart

or

/etc/rc.d/rc7.d/S90mysqld restart

6. Check installed rpms

cd /root

rpm -qa MySQL*

should display

MySQL-devel-4.0.20-0

MySQL-client-4.0.20-0

MySQL-server-4.0.20-0

MySQL-shared-compat-4.0.18-0

7. Check that mysql works and shows the databases

mysql

will display

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 1 to server version: 4.0.20-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

At the mysql prompt do

mysql> show databases;

+----------+

| Database |

+----------+

| horde |

| mysql |

| phpbb |

| test |

+----------+

5 rows in set (0.00 sec)

mysql> exit;

Bye