blob: 822a2b9a884b109bd8d2277eb47b0d7b20d22638 (
plain) (
tree)
|
|
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
}
|