blob: 0bd1aa8d3863921337688ae2647ca00bc7207e34 (
plain)
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
|
#!/bin/sh
set -e
MYSQLD=/usr/sbin/mysqld
DIR=`dirname $0`
DIR_FULL=`realpath $DIR`
ROOT=$DIR_FULL/mysqld
PID_FILE="$ROOT/mysql.pid"
MY_CNF="$ROOT/my.cnf"
PORT=3316
ROOTPW=123456
usage() {
me=`basename $0`
echo "$me: runs a local instance of apache (on port $PORT)"
echo "Usage: $me <start|stop|restart|reload|status> - the usual"
echo "Usage: $me <init|clean> - install / remove the databases"
}
run_mysqld() {
$MYSQLD \
--defaults-file=$MY_CNF \
--basedir=$ROOT \
--pid-file=$PID_FILE \
--port=$PORT \
--socket=$ROOT/socket \
"$@" &
}
run_mysql_upgrade() {
mysql_upgrade \
--defaults-file=$MY_CNF \
"$@"
}
init_mysql() {
(
echo "CREATE DATABASE mysql;"
#echo "GRANT ALL on *.* to 'root'@'localhost' identified by '$ROOTPW';"
echo "USE mysql;"
cat /usr/share/mysql/mysql_system_tables.sql
echo "UPDATE user SET password=PASSWORD("$ROOTPW") WHERE user='root';"
echo "FLUSH PRIVILEGES;"
) | run_mysqld --bootstrap
set -x
sleep 5
run_mysqld
sleep 5
run_mysql_upgrade
"$0" stop
set +x
}
case "$1" in
start) shift; run_mysqld "$@";;
init) init_mysql;;
stop) kill `cat "$PID_FILE"`;;
restart)
"$0" stop
#sleep 1
"$0" start
;;
reload) kill -HUP `cat "$PID_FILE"`;;
status)
if [ -f "$PID_FILE" ]; then
ps `cat "$PID_FILE"`
else
echo "Not running"
fi
;;
clean)
# TODO: stop? Check if we're alive?
rm -rf $ROOT/data/*
;;
*) usage; exit 1;;
esac
|