DB Setup at Linode on Ubuntu 9.04.txt

# Anything between dashes gets copied into the file preceding it.
# Brackets hold notes and instructions

hostname foo.com
vi /etc/hostname
---------------------------------
foo.com
---------------------------------

mkdir .ssh
chmod 700 .ssh/
touch .ssh/authorized_keys
chmod 600 authorized_keys
vi .ssh/authorized_keys
[ Paste in your public key ]

dpkg-reconfigure tzdata
[Select Other, then UTC]

[ Setup an internal IP address
vi /etc/network/interfaces
---------------------------------
auto eth0:0
iface eth0:0 inet static
    address 999.999.999.999
    netmask 999.999.999.999
---------------------------------


vi /etc/ssh/sshd_config
---------------------------------
Port 2223
---------------------------------

reboot

vi  /etc/apt/sources.list
[Uncomment all]

apt-get update
apt-get install screen
screen
apt-get upgrade

apt-get install ufw
ufw default deny
ufw allow 2223/tcp
[ The following allows you to enable communication between other servers in you private lan ]
ufw allow from 999.999.999.999
ufw enable

vi ~/.my.cnf
---------------------------------
[client]
user = root
password = xxxxx
---------------------------------

apt-get install mysql-server
vi /etc/mysql/conf.d/utf8.cnf
---------------------------------
[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'

[mysql]
default-character-set=utf8
---------------------------------

vi /etc/mysql/conf.d/utf8.cnf
[ Paste config from http://gist.github.com/186806 ]

/etc/init.d/mysql stop
rm /var/lib/mysql/ib_logfile*
/etc/init.d/mysql start