Virtualmin update Apache, PHP, MySQL and BIND to latest

MySQL
First we need to download a rpm for our system architecture and version of mysql-server we wish to install in this case I am installing on a 32bit operating system and mysql-server 5.5.10.

http://pkgs.org/centos-5-rhel-5/remi-testing-i386/mysql-server-5.5.10-1.el5.remi.i386.rpm.html

Here is a link to the mysql-server rpm I will be using for installation; to download the file to the system we can use wget if it’s not found then run yum install wget.

Wget http://rpms.famillecollet.com/enterprise/5/test/i386/mysql-server-5.5.10-1.el5.remi.i386.rpm

The command above will download the mysql-server rpm into the directory we are current in which should be /tmp; there are some other files we need to update before installation which are mysql and mysql-lib. To find them you use the exact same method we used to download the mysql-server file.

Wget http://rpms.famillecollet.com/enterprise/5/test/i386/mysql-libs-5.5.10-1.el5.remi.i386.rpm
Wget http://rpms.famillecollet.com/enterprise/5/test/i386/mysql-5.5.10-1.el5.remi.i386.rpm

The two commands above will download the two RPM’s I will be using to install the required packages. The next step is to install mysql-libs, mysql and mysql-server which are done by typing the following commands.

rpm –Uhv mysql-libs-5.5.10-1.el5.remi.i386.rpm
rpm –Uhv mysql-5.5.10-1.el5.remi.i386.rpm
rpm –Uhv mysql-server-5.5.10-1.el5.remi.i386.rpm

You may receive some messages about file conflicts if you do then please add –-force to the end of the command and that will force the new files to overwrite the old files, if you receive any messages about missing dependencies then you will need to install or update them to the required version, if it complains about a file being needed by an older version of mysql-server then use the –-nodeps option which will force the installation and overwrite the old files. For example the commands I have to run on my system are:

rpm –Uhv mysql-libs-5.5.10-1.el5.remi.i386.rpm –force
rpm –Uhv mysql-5.5.10-1.el5.remi.i386.rpm
rpm –Uhv mysql-server-5.5.10-1.el5.remi.i386.rpm --nodeps

Now my MySQL is updated to 5.5.10 but we are not finished just yet, because MySQL was update we need to run a command which will check through are database tables and make any modifications so that it is compatible with the new version of MySQL.

mysql_upgrade -–password=yourpassword

The following command will go through the database and fix any errors you must replace yourpassword with the MySQL root password.

A restart of mysql will finish the process.

service mysql-server restart

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.