blob: 5b997196f532d80f495ee744757da9c03d92343c (
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
|
mysql_add_db() {
echo "# Creating mysql database $1..."
echo "create database $1;" | mysql -u root
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
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 <<-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 <<-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 -h localhost "$2" < "$1"
ERR=$?
if [ "$ERR" -ne 0 ]; then
perror "Could not import sql dump file $1!"
fi
}
|
