blob: 822a2b9a884b109bd8d2277eb47b0d7b20d22638 (
plain) (
blame)
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
|
preset_mysql_root() {
# Presetting a root password for mysql so installer keeps quiet:
echo "Presetting root password for mysql: $MYSQL_ROOT_PASS"
debconf-set-selections <<< "mysql-server mysql-server/root_password password $MYSQL_ROOT_PASS"
debconf-set-selections <<< "mysql-server mysql-server/root_password_again password $MYSQL_ROOT_PASS"
}
mysql_add_db() {
echo "# Creating mysql database $1..."
echo "create database $1;" | mysql -u root -p"$MYSQL_ROOT_PASS"
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not create mysql database $1!"
fi
}
mysql_delete_db() {
# $1 database; $2 password
echo "# Deleting mysql database $1..."
echo "drop database if exists $1;" | mysql -u root -p"${2}"
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not delete mysql user $1!"
fi
}
mysql_add_user() {
# $1=user, $2=database, $3=privileges, $4=password
echo "# Adding user $1 for database $2, privileges $3..."
mysql -u root -p"$MYSQL_ROOT_PASS" <<-CMDS
CREATE USER '$1'@'localhost' IDENTIFIED BY '$4';
GRANT $3 ON $2.* TO '$1'@'localhost';
CMDS
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not add mysql user!"
fi
}
mysql_add_privs() {
# $1=user, $2=database, $3=privileges
echo "# Adding privileges $3 for user $1 on database $2..."
mysql -u root -p"$MYSQL_ROOT_PASS" <<-CMDS
GRANT $3 ON $2 TO '$1'@'localhost';
CMDS
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not add privileges!"
fi
}
mysql_delete_user() {
# $1: mysql user, $2 password
echo "# Deleting mysql user $1..."
echo "drop user $1@localhost;" | mysql -u root -p${2}
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not delete mysql user $1!"
fi
}
mysql_import_dump() {
# $1: dump file, $2: database
echo "# Importing sql dump file $1..."
mysql -u root -p"$MYSQL_ROOT_PASS" -h localhost "$2" < "$1"
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not import sql dump file $1!"
fi
}
|
