Installing MySQL 5.0 on Fedora Core 4

By default, I’m a Windows user. The last time I used Linux or Unix platform heavily was back then in Cornell, around 10 years or so ago. I have lost my touch and limited skills, and I think it’s time to hone them.

The goal is to run MySQL 5.0 and PostgreSQL on Fedora Core 4 so that I can do various testing and development works, such as replication (I don’t have enough machines to do clustering and so that has to wait) and perhaps start on my Mono project.

The first thing to do was to Google on ‘how to install fedora core 4’ and ‘how to install mysql 5 on fedora core 4’. Well, I didn’t really like what I saw – a lot of people complained about plenty of problems. But, surprisingly, it didn’t take me too long to successfully get the box up and running. Or may be I was just lucky, heh.

• Pentium 4 1.4GHz
• 256MB of RAM
• 40G Hard Drive
• Boot to Fedora Core 4 DVD and install using the graphical interface
• Skip the Media Check
• Select the Server installation
• Disable the Firewall and SELinux
• Add the followings in the Packages:
  • Gnome – IMHO Gnome is much better than KDE, but some other people think otherwise. It’s totally up to you
  • Graphical Internet
  • FTP
  • MySQL Database
  • Development Tools
• Click through to complete the installation
• Create a default user
• Login to the box using root
• Open up Firefox and download the followings:
  • http://dev.mysql.com:
    • MySQL-server-community-5.0.37-0.rhel4.i386.rpm
    • MySQL-client-community-5.0.37-0.rhel4.i386.rpm
    • MySQL-shared-compat-5.0.37-0.rhel4.i386.rpm
    • mysql-gui-tools-5.0r11-rhel4-i386.tar.gz
  • http://rpm.pbone.net/index.php3/stat/4/idpl/1991817/com/ptt-beta2.i386.rpm.html:
    • ptt-beta2.i386.rpm
  • http://rpm.pbone.net/index.php3/stat/4/idpl/1692645/com/j2re-1.4.2-11.2.el4.rf.i586.rpm.html
    • j2re-1.4.2-11.2.el4.rf.i586.rpm
• Remove the existing MySQL 4.1:
  • yum remove '*mysql*'
• Install MySQL 5.0 Server & Client:
  • rpm –i MySQL-server-community-5.0.37-0.rhel4.i386.rpm
  • rpm –i MySQL-client-community-5.0.37-0.rhel4.i386.rpm
• Start, Stop & Restart MySQL Server, and create a root password:
  • /etc/init.d/mysql start | stop | restart
  • mysqladmin –u root password ‘’
• Login to MySQL Client:
  • mysql –u root –p
  • Enter your root password
  • mysql> drop database test;
  • mysql> quit;
• Install MySQL GUI Tools (Administrator & Browser):
  • rpm –i ptt-beta2.i386.rpm
  • rpm –i j2re-1.4.2-11.2.el4.rf.i586.rpm
  • rpm -i MySQL-shared-compat-5.0.37-0.rhel4.i386.rpm
  • tar –zxf mysql-gui-tools-5.0r11-rhel4-i386.tar.gz
  • rpm –ivh mysql-gui-tools-5.0r11-1rhel4.i386.rpm
  • rpm –ivh mysql-administrator-5.0r11-1rhel4.i386.rpm
  • rpm –ivh mysql-query-browser-5.0r11-1rhel4.i386.rpm
• Finally, run your MySQL Administrator (from Start Menu -> Programming -> MySQL Administrator) and enter your login information:
  • Server hostname: localhost
  • Username: root
  • Password:

And we're DONE!

At the moment, I have this box running as a Slave server (READ only) for the Covalentia.2.2 (Enterprise Edition) Live Demo at our Mirror Site at covalentia.dyndns.org. Feel free to check it out ;)