Article ID: 2762, created on Oct 29, 2007, last review on May 1, 2014

  • Applies to:
  • Pro Control Panel Linux

AdditionalInformation

View Knowledge
Knowledge ID 2109
Product : EnsimPro on Linux(Fedora)
Version : 4.0
Topic : FAQ

Title
Copy of Upgrade to MySQL version 4.1.x

Summary
Copy of Upgrade to MySQL version 4.1.x

Prevention


Details

To upgrade from MySQL version 3.23 to version 4.1.x you will first need to upgrade to version 4.0.x and then upgrade the mysql version to 4.1.x. Direct upgrade from version 3.23 to version 4.1.x is known to cause issues.

The following steps are required to upgrade to version 4.1.x:

1. For upgrading from 3.23 to 4.0.23

Download following rpms's from mysql.com
http://dev.mysql.com/downloads/mysql/4.0.html

MySQL-server-4.0.23-0.i386.rpm
MySQL-client-4.0.23-0.i386.rpm
MySQL-devel-4.0.23-0.i386.rpm
MySQL-shared-4.0.23-0.i386.rpm
MySQL-shared-compat-4.0.23-0.i386.rpm

2. Install the downloaded packages from Step 1 as follows:
 a. service mysqld stop
 b. rpm -Uvh *.rpm
 c. set_pre_maintenance
 d. set_maintenance
 e. set_post_maintenance
 f. exit_post_maintenance

3. Verify that the mysql service is running properly.

4. For upgrading from 4.0.23 to 4.1.9

Download following rpms's from mysql.com
http://dev.mysql.com/downloads/mysql/4.1.html

MySQL-server-4.1.11-0.i386.rpm
MySQL-client-4.1.11-0.i386.rpm
MySQL-devel-4.1.11-0.i386.rpm
MySQL-shared-4.1.11-0.i386.rpm
MySQL-shared-compat-4.1.11-0.i386.rpm

5. Install the downloaded packages from Step 4 as follows:
 a. service mysqld stop
 b. rpm -Uvh *.rpm
 c. set_pre_maintenance
 d. set_maintenance
 e. set_post_maintenance
 f. exit_post_maintenance

6. Run the mysql_fix_privilege_tables command to increase the length of the Password column from 16 to 41 bytes. MySQL 4.1.x now has longer password hash then earlier versions for better security. (The script does not change the existing password values, which remain 16 bytes long)

/usr/bin/mysql_fix_privilege_tables

7. Due to the change in the Password hash the pre 4.1 clients (like phpMyAdmin) does not authenticate the existing user. To have the backward compatibility with pre-4.1 clients one need to start the mysql daemon with --old-passwords option. To do so modify the /etc/rc.d/init.d/mysqld_app_init script as follows:

Look for the line

SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf --pid-file=$PID_FILE "

change it to

SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf --pid-file=$PID_FILE --old-passwords"

then look for a line
 
SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf.admin_appl --skip-grant-tables --skip-networking"

change it to

SAFE_MYSQLD_OPTIONS="--defaults-file=/etc/my.cnf.admin_appl --skip-grant-tables --skip-networking --old-passwords"

8. Restart mysql service

service mysql restart

6. Verify that the mysql service is upgraded to version 4.1.x and running properly.


Attachments


Related Knowledge

Related Links
 
Last ModifiedUsageSatisfiedLast Used
9/23/2005 3:02:45 PM   

4cc899da08664637a8bc437308d3ddd7 3ccb419cf98083f3bb45808fba8dbc7c 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF