cwsaylor (owner)

Revisions

gist: 186802 Download_button fork
public
Public Clone URL: git://gist.github.com/186802.git
Embed All Files: show embed
DB Setup at Linode on Ubuntu 9.04.txt #
raw 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80

# 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