rpm based mysql5 install

{
if ! grep -qai '^rpm "http://mirror.centos.org/centos"' /etc/apt/sources.list ; then
echo 'rpm "http://mirror.centos.org/centos" /4/apt/i386 addons centosplus' >> /etc/apt/sources.list
addedcentos=1
fi
apt-get update
apt-get dist-upgrade -y mysql-server
/etc/init.d/mysqld restart
chkconfig --level 35 mysqld on
#sed --in-place 's%^rpm "http://mirror.centos.org/centos"%#rpm "http://mirror.centos.org/centos"%' /etc/apt/sources.list
}

{
# install mysql-server if you aren't running it already
apt-get install mysql-server
/etc/init.d/mysqld start
# read in a password and set the password
if [ -z "$rootpasswd" ]; then
echo -n 'enter password '
read rootpasswd
fi
mysqladmin password $rootpasswd
# stop mysql
/etc/init.d/mysqld stop
}

function installmysql() {
# latest version at time of posting
version=5.0.27-0
major=5.0
#rhel4 may also work
distro=rhel3
files="MySQL-client-standard-$version.$distro.i386.rpm MySQL-server-standard-$version.$distro.i386.rpm MySQL-shared-compat-$version.i386.rpm"
# if you have this directive mysql server will not install so comment it out
replace "^bdb_cache_size" "#bdb_cache_size" -- /etc/my.cnf
for file in $files; do 
    if [ -e $file ]; then continue; fi
    url=http://mysql.mirrors.pair.com/Downloads/MySQL-$major/$file; 
    echo getting $url
    wget $url
    if [ $? -ne 0 ] ; then echo failed getting rpm ; return 1; fi
done
/etc/init.d/mysqld stop
if [ ! -e /etc/my.cnf.orig ]; then
mv /etc/my.cnf /etc/my.cnf.orig
fi
rpm -Uvfh $files
# need the mysql user else mysql will not start up
adduser mysql; chown -R mysql:mysql /var/lib/mysql
/bin/mv -f /usr/share/mysql/my-small.cnf /etc/my.cnf
/etc/init.d/mysql restart
chkconfig --level 35 mysql on
}
installmysql

[root@vps ~]# mysql_upgrade
[root@vps ~]# mysql_fix_privilege_tables