tim's journal

Installing MySQL

This is BOINC continued. We need to install MySQL, recompile PHP, etc. But first things first. Previously I was unable to install MySQLdb for Python.

1. We grab the rpm's for MySQL 4.0.15. We'll need the server, client, and the dynamic client libraries (including 3.23.x libraries). Since we'll have to compile PHP again, we'll also need the developer stuff. My box does not even have a browser, so I used 'wget' to get the files from one of the mirrors in Santa Clara.

   wget http://mysql.zawodny.com//Downloads/MySQL-4.0/MySQL-server-4.0.15-0.i386.rpm
   wget http://mysql.zawodny.com//Downloads/MySQL-4.0/MySQL-client-4.0.15-0.i386.rpm
   wget http://mysql.zawodny.com//Downloads/MySQL-4.0/MySQL-shared-compat-4.0.15-0.i386.rpm
   wget http://mysql.zawodny.com//Downloads/MySQL-4.0/MySQL-devel-4.0.15-0.i386.rpm

2. Now we can install the packages (in the same order) using 'rpm -i', e.g.,

   rpm -i MySQL-server-4.0.15-0.i386.rpm

3. When you are done with the packages, you should be able to set the MySQL root password using

   /usr/bin/mysqladmin -u root password 'new-password'
   /usr/bin/mysqladmin -u root -h brainwave.stanford.edu password 'new-password'

4. Setup the symlink for mysql.sock

   ln -s /var/lib/mysql/mysql.sock /tmp

5. Now you can install python MySQLdb using

   rpm -i MySQL-python-0.9.2-1.i386.rpm