#!
#tar -xvzf mysql-4.0.16.tar.gz
#if test ! -d "../../bin/linux"; then
#  mkdir ../../bin/linux
#fi
#if test ! -d "../../bin/linux/mysql" ; then
#  mkdir ../../bin/linux/mysql
#fi
#HOME=`pwd`
#cd mysql-4.0.16
#`./configure --prefix=$HOME/bin/linux/mysql --libexec=$HOME/bin/linux/mysql/libexec`
#chmod $HOME/
#make

# install the databases if necessary - only run this the FIRST time that the
# database is created!!!
#./bin/mysql_install_db

# create the gsdl3admin and gsdl3reader users...
./bin/mysql --user=root --execute="GRANT SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON *.* TO gsdl3admin@localhost;"
./bin/mysql --user=root --execute="GRANT SELECT ON *.* TO gsdl3reader@localhost;"
#./bin/mysql --user=root --execute="REVOKE SELECT,INSERT,DELETE,UPDATE,DROP,CREATE ON mysql.* FROM gsdl3admin@localhost;"