Dan's Wiki

Available only inside the local network at 192.168.0.10. This DNS'ed by the DSL router to “ivan.”

To install sudo (info: http://www.linuxhelp.net/guides/sudo/) apt-get install sudo Then, anyone in the “sudo” group can run sudo. Ran “usermod -a -G sudo dwheele” to grant sudo

To install mysql

sudo apt-get update sudo apt-get dist-upgrade

sudo apt-get install mysql-server mysql-client It asked for a new root password, provided '–rootPW–'

Instructions recommend, but not needed: sudo mysqladmin -u root -h localhost password '–rootPW–' sudo mysqladmin -u root -h myhostname password '–rootPW–'

Ran this, which seemed to modify apache2 sudo apt-get install php5-mysql

You can now access your MySQL server like this:

mysql -u root -p

apt-get install samba

cd /etc/samba sudo smbpasswd -a dwheele

sudo apt-get install ssh

mysql -u root -p create database rempat_db

create user 'rempat'@'%' identified by 'pat2gist';

grant all on rempat_db.* to 'rempat'@'%';

If you can't create a user, try deleting old stuff like this:

  delete from mysql.user where user=foo;
  delete from mysql.db where user=foo

or

  flush privileges;

(at the mysql prompt)

Had to enable remote access, by modifying /etc/mysql/my.cnf, changing bind-address to 192.168.0.11