/usr/local/mysql/bin/mysql
You can't offer music (mp3, wma, etc) for download, nor movie files, unless you can clearly prove to me that you're the copyright holder of those works. Even in that case, you need to know that redgum is a server for all students of the campus and can't be used as a base for a site that provides lots of downloads. Don't despair as there are plenty of good alternatives for you - hosting companies offer your own site for as little as $5 per month these days. YouTube etc let you serve movies free. Keep in mind that redgum is a community server - there are over 4,000 students with accounts, it's a shared resource, so think hard about how much disk space you use. And of course you can't run a business or commercial site from redgum. It's an educational resource. I shouldn't have to say this, but - "inappropriate" material, illegal activities etc will earn offenders big trouble.
I can't help you with getting your site running apart from giving you your initial account. I can't provide tuition on how to connect to your database, or how to upload files. I can't help you with "internal server errors" (check your permissions!) or tricky stuff. You have tutors and lecturers who want to help you - ask them. Check the logs on redgum if you are running into problems (/var/log/httpd/access_log and /var/log/httpd/error_log). If you want your site to work it must have at least an index.html or index.php present in your public_html directory, otherwise you need to give out an explicit url such as http://redgum.bendigo.latrobe.edu.au/~yourusername/yourpage.html
Logs are monitored. As part of your conditions of use, your activity on the systems here at La Trobe can and will be monitored, if you step over the line you'll find action may be taken without consulting you first, such as taking your site off-line. However the overwhelming odds are that since you are reading this you're interested in learning and honing your skills, so I encourage you to use redgum to build an interesting site, experiment with php, perl and Web2.0 technologies, and build a site you're proud of. Send me a link !