MySQL Sysadmin's Guide

Installed Versions

3.23.58 (Solaris)

3.23.49 (Solaris)

4.0.16 (Linux)

3.23.58

3.23.58 was installed locally on rainier in /usr/local/mysql-3.23.58-sun-solaris2.8-sparc/, with a symlink /usr/local/mysql pointing to it. The data files are still on xraid in /l/local/packages/MySQL/3.23.49/data/.

Backups

User emysql has a cron job on rainier that executes nightly that uses mysqldump to create a full backup of all the databases. This is stored as ~emysql/backups/rainier/backup_all.sql. logrotate is then used to keep 7 days worth of these, compressed.

3.23.49

Download (Solaris binary)

http://mirror.sit.wisc.edu/mysql/Downloads/MySQL-3.23/mysql-3.23.49-sun-solaris2.8-sparc.tar.gz

Logs

solaris install - 3-1-2002

Configuration

% Set root password
/l/local/packages/MySQL/3.23.49/bin/mysqladmin -u root password '<super secret password>'
/l/local/packages/MySQL/3.23.49/bin/mysqladmin -u root -h rainier.extreme.indiana.edu password '<super secret password>'


/l/local/packages/MySQL/3.23.49/bin/mysql -u root -h rainier.extreme.indiana.edu -p
% Creating Databases
mysql> create database IUExtremeMDB;
mysql> create database WRFMDB;
mysql> create database componentBrowser;
mysql> create database eventdb;


% Creating regular Users and granting rights
mysql> grant all on IUExtremeMDB.* to yuma@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on WRFMDB.* to yuma@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;

mysql> grant all on componentBrowser.* to ranantha@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;

mysql> grant all on eventdb.* to ysimmhan@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on eventdb.* to aslom@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on eventdb.* to arossi@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;
mysql> grant all on eventdb.* to mafarrel@"%.extreme.indiana.edu" identified by '<super secret password>' with grant option;

mysql> grant all privileges on *.* to ysimmhan@localhost identified by '<super secret password>' with grant option;
mysql> grant all privileges on *.* to ysimmhan@"%" identified by '<super secret password>' with grant option;


% Creating virtual Users and granting rights
mysql> grant insert, delete, select, update on IUExtremeMDB.* to FileManager@"%";
mysql> grant insert, delete, select, update on IUExtremeMDB.* to FileManager@localhost;

mysql> grant insert, delete, select, update on componentBrowser.* to cb@"%" identified by 'z/x.c,';
mysql> grant insert, delete, select, update on componentBrowser.* to cb@localhost identified by 'z/x.c,';

mysql> grant insert, delete, select, update on eventdb.* to eventuser@"%";
mysql> grant insert, delete, select, update on eventdb.* to eventuser@localhost;

% Save privileges
mysql> flush privileges;


% Export data from previous installation ...
bin/mysqldump -h rainier.extreme.indiana.edu -u root -p IUExtremeMDB > ~/scratch/iu_extreme_mdb
bin/mysqldump -h rainier.extreme.indiana.edu -u root -p WRFMDB > ~/scratch/wrf_mdb
bin/mysqldump -h rainier.extreme.indiana.edu -u root -p componentBrowser > ~/scratch/component_browser
bin/mysqldump -h brick.extreme.indiana.edu -u root -p --no-data eventdb > ~/scratch/event_db

% ... and Import it into current installation
bin/mysql -h rainier.extreme.indiana.edu -u root -p IUExtremeMDB < ~/scratch/iu_extreme_mdb
bin/mysql -h rainier.extreme.indiana.edu -u root -p WRFMDB < ~/scratch/wrf_mdb
bin/mysql -h rainier.extreme.indiana.edu -u root -p componentBrowser < ~/scratch/component_browser
bin/mysql -h rainier.extreme.indiana.edu -u root -p eventdb < ~/scratch/event_db

4.0.16

Download (Linux binary)

http://www.mysql.com/get/Downloads/MySQL-4.0/mysql-standard-4.0.16-pc-linux-i686.tar.gz/from/http://mirror.services.wisc.edu/mysql/

Logs

linux install - 24-Nov-2003

Configuration

% Set root password
bin/mysqladmin -u root -p password 'new-password'
bin/mysqladmin -u root -h linbox1.extreme.indiana.edu password 'new-pasword'

% login and create database GSX and users.
bin/mysql -u root -h localhost -p

% Creating Users and granting rights
grant all on GSX.* to gsx_admin@"%.extreme.indiana.edu" identified by 'qwerty' with grant option;

grant create, drop, insert, select, update, delete on GSX.* to gsx_user@"%";
grant create, drop, insert, select, update, delete on GSX.* to gsx_user@localhost;

flush privileges;