summaryrefslogtreecommitdiffstats
path: root/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh
diff options
context:
space:
mode:
Diffstat (limited to 'rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh')
-rwxr-xr-xrubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh22
1 files changed, 21 insertions, 1 deletions
diff --git a/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh b/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh
index 5b5362ab..01a718d9 100755
--- a/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh
+++ b/rubbos/rubbos_scripts/1-1-1/scripts/MYSQL1_configure.sh
@@ -6,8 +6,10 @@ source set_bottlenecks_rubbos_env.sh
echo "CONFIGURING MYSQL on $HOSTNAME"
cd $MYSQL_HOME
+chown -R mysql:mysql ./
cp support-files/my-medium.cnf /etc/my.cnf
-bin/mysqld_safe --user=$BOTTLENECKS_USER &
+#bin/mysqld_safe --user=$BOTTLENECKS_USER &
+bin/mysqld_safe&
sleep 10
#bin/mysqladmin -u root password 'new-password'
cp support-files/mysql.server /etc/init.d/mysql.server
@@ -19,4 +21,22 @@ fi
ln -s $MYSQL_HOME/bin/mysql /usr/local/bin/mysql
+sleep 20
+
+cat << EOF | mysql -uroot
+
+CREATE DATABASE rubbos;
+
+GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'%' \
+ IDENTIFIED BY 'rubbos';
+ flush privileges;
+GRANT ALL PRIVILEGES ON rubbos.* TO 'rubbos'@'localhost' \
+ IDENTIFIED BY 'rubbos';
+ flush privileges;
+EOF
+
+tar xzf /tmp/$RUBBOS_DATA_TARBALL
+mysql -uroot rubbos < $RUBBOS_DATA_SQL
+rm $RUBBOS_DATA_SQL
+
echo "DONE CONFIGURING MYSQL on $HOSTNAME"