CS469/569 - Linux and Unix Administration and Networking Spring 2022

Displaying ./code/04-21/README

h9
- graded
- grade in canvas. to see comments, handin on the server -
  handin -g h9
- mysql
  + some people have users like "root@localhost" - anything in quotes
    is treated as part of the string, and that is allowed in the
    username
  + some people have granted access to all databases for their drupal
    or wiki users.  that is a big no-no.
  + some people have database or usernames that are not informative,
    you should use drupal or wiki in the database/usernames somewhere
    to be more informative.
- security
  + by default, both drupal and mediawiki leave the database username
    and password stored in plaintext in a settings file and readable
    by all users on the system.  that is bad, so should make the
    following files owned by apache, group apache, and /not/
    read/write/execute by "other" -
      /net/web/drupal/sites/default/settings.php
      /net/web/wiki/LocalSettings.php

q10
- graded, you can see your answers and comments in canvas now
- first problem, correct solution is
    set password for stripe@u11 = password('thingsome');
  I had a mistake in the model solution on the quiz.
- second problem, correct solutions people used -
  mysql -B -e 'show databases;'
  echo "show databases;' | mysql --batch
  show databases;
  mysqlshow | tail +4 | tr -d '|' | sed 's/ //g' | grep -v '+---*'
  mysqlshow
- question asking to backup database, correct answer is
  mysqldump info > backup.sql