OK so I've gone through a lot just to get ruby and rails installed on
RHEL 4 64bit, but it works, kinda. I'm building a software management
system and decied to try out ruby on rails. Anyways here is a bit of
history of what i've done

Here is the mysql command that made one of the tables

CREATE TABLE users(
id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
staffid INTEGER(20) UNSIGNED NOT NULL DEFAULT '00000000',
name VARCHAR(35) NOT NULL DEFAULT '',
title VARCHAR(10) NOT NULL DEFAULT '',
dept VARCHAR(20) NOT NULL DEFAULT '',
institute VARCHAR(50) NOT NULL DEFAULT '',
office VARCHAR(20) NOT NULL DEFAULT '',
email VARCHAR(40) NOT NULL DEFAULT '',
phone VARCHAR(11) NOT NULL DEFAULT '',
created_on TIMESTAMP(14) NOT NULL,
updated_on TIMESTAMP(14) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY staffid_key (staffid)
) ENGINE=InnoDB COMMENT='User information';

Put the database info in config/database.yml
And ran:
ruby script/generate scaffold user

And now when I go to www.example.com/manage/user I get
Lost connection to MySQL server during query: SELECT COUNT(*) FROM
users

I've also have ran gem install mysql -- --with-mysql-config

So whats going on?