Packaging MySQL on Andrew Linux

Short Description
This document assumes that you have some base familiarity with Systems Administration, administrative privileges on the system(s) that you are about to modify, and a passing familiarity with the Andrew Package System1. Finally, you have an understanding of how to modify files, and more importantly which files you shouldn’t modify.

Website: www.cmu.edu | Filesize: 567kb
No of Page(s): 8

Content
…
Step by Step Installation
1. First, we will create an /etc/my.cnf file to configure the attributes of the MySQL database engine. The example file that we will use, uses the INNODB model which makes the database engine more robust.
2. Next we will need to create the data directory, which is referred to as the datadir in /etc/my.cnf, and in various places within the document.
3. Modify /etc/package.proto to include the %doesmysql definition, and to protect our version of /etc/my.cnf or optionally include a file from an AFS path.
4. Once /etc/package.proto completes we will need to run /etc/mpppackage to add the files included in our package definition to our Andrew Linux System.
5. Become the user database to initialize and configure the MySQL engine.
6. Restart the MySQL database
7. Set the MySQL root (administrative) password
8. Create a simple test database and user.
…