Due Date: April 8, 2003
Value: 15 points total
Submission: MySQL (Stage 1), Web Based Database (Stage 2 - if we can figure out gcc problem)
- Send the instructor an e-mail telling when you have completed the first part. Send along the system name, port number of the database, root password for access, and the URL of the web pages to firstname.lastname@example.org.
- Post an e-mail to the class list containing the written part of the assignment (part 2). Use the following subject line: Your Name - Assignment 5
Part 1 (10 pts)
- Install and Configure MySQL (Stage 1)
- Create the web-based database-driven system outlined in the RedHat Book (p 161)
Part 2 (5 pts)
- Locate and read, from any professional journal, two articles relevant to the area of the methods for delivering audio and video content in a network environment and/or on there advantages and disadvantages of the approaches. Write a two paragraph review for each article. The 1st paragraph should describe the contents of the article. The 2nd paragraph should be your reaction to the article. Do not forget to include the reference cite. Use APA format.
- Reply to at least two postings in a meaningful manner. Be sure to include
your name in the subject line like: Re: There Name - Assignment #5 - Your Name
Stage 1 - MySQL Install
Read pages 161-162
Refer to this section instead of page 163, Steps 1, 2, and 3.
Installing and getting MySQL Operational without RPM
Steps for MySql 4.0.12
Place in /usr/local/src
tar -xvf mysql-standard-4.0.12-pc-linux-i686.tar
create a directory link between /usr/local/mysql and the new mysql directory
shell> ln -s /usr/local/src/mysql-standard-4.0.12-pc-linux-i686 /usr/local/mysql
NOTE: The mysql-standard-4.0.12-pc-linux-i686 will change depending on the version of mysql you downloaded and the entire path will depend on where you downloaded the mysql source to. In this case, I downloaded it into /usr/local/src
Add a user and group for mysql. These commands add the mysql group and the mysql user.
shell> groupadd mysql
shell> useradd -g mysql mysql
Change into the intended installation directory:
shell> cd /usr/local
Continue with the install
shell> cd /usr/local/mysql
shell> chown -R root .
shell> chown -R mysql data
shell> chgrp -R mysql .
Begin the mysql deamon
shell> bin/mysqld_safe --user=mysql &
When you are ready to automate the start of the process:
Later on add this command to the rc.local
Note: Any new data goes into /usr/local/mysql/data
Ways to test
shell> cd /usr/local/mysql/bin
shell> ./mysqladmin version
This should return the version
continue with Step 4 on page 163
RedHat 165 - 168
Error on Page 168
be sure to add a value for the Owner field. That field is missing from the example and you will get the following error if you leave it out.
ERROR 1136: Column count doesn't match value count at row 1