MySQL v5 install
From Darwin
Contents |
MySQL V5 (User DBs) installation procedure
Download
- downloaded 5.0.51 of the community server from: http://dev.mysql.com/downloads/mysql/5.0.html
- Linux (non RPM, Intel C/C++ compiled, glibc-2.3) downloads (pre-compiled binaries) from: http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.51a-linux-x86_64-icc-glibc23.tar.gz/from/http://mirror.services.wisc.edu/mysql/
- unpacked into /home/software and made link: ln -s mysql-5-0-51a-linux-x86_64-icc-glibc23 mysql
Installation
- followed install directions in v5.0 documentation: http://dev.mysql.com/doc/refman/5.0/en/index.html
- created subdirs: ./var/lib, ./var/log, ./var/run/mysqld & /data/mysql/data
- chown mysql:mysql of all software and data dirs
- initialized the DB: scripts/mysql_install_db --user=mysql --basedir=/home/software/mysql --datadir=/data/mysql/data
- created ./my.cnf startup config file with all the env defs to run a 2nd instance of the server using non-std locations for the software and data dirs.
- cp support-files/mysql.server /etc/init.d/mysqld5 and edited it to start up a 2nd server with diff lock files
- created modulefiles/mysql/5.0/mysql5 for users
Post-Installation
- chkconfig mysqld5 on
- changed root password and added beagle.local to the user grant table.
- ran the benchmark test suite: sgl-bench/run-all-tests --log
- granted Dirk all privs to admin the DB.
