Work around mariadb grant issue

38e0a563 · Chris Hofstaedtler · e1d386c5 · 38e0a563
Commit 38e0a563 authored 8 years ago by Chris Hofstaedtler
--- a/debian/start_mysqld_and_run.sh
+++ b/debian/start_mysqld_and_run.sh
@@ -18,7 +18,11 @@ DO_MYSQL_DBNAME=test
 DO_MYSQL_DATABASE=/${DO_MYSQL_DBNAME}

 mysql_install_db --no-defaults --datadir=${MYTEMP_DIR} --force --skip-name-resolve --user=${DO_MYSQL_USER}
-/usr/sbin/mysqld --no-defaults --user=${DO_MYSQL_USER} --socket=${MYSQL_UNIX_PORT} --datadir=${MYTEMP_DIR} --skip-networking &
+cat >${MYTEMP_DIR}/init.sql <<EOT
+UPDATE mysql.user SET plugin = "";
+FLUSH PRIVILEGES;
+EOT
+/usr/sbin/mysqld --no-defaults --user=${DO_MYSQL_USER} --socket=${MYSQL_UNIX_PORT} --datadir=${MYTEMP_DIR} --skip-networking --init-file=${MYTEMP_DIR}/init.sql &
 echo -n pinging mysqld.
 attempts=0
 while ! /usr/bin/mysqladmin --socket=${MYSQL_UNIX_PORT} ping ; do
@@ -36,7 +40,7 @@ cleanup() {
 }
 trap cleanup INT EXIT TERM

-# database `test` is already created by default
-mysql --user=${DO_MYSQL_USER} --socket=${MYSQL_UNIX_PORT} --execute "GRANT ALL PRIVILEGES ON ${DO_MYSQL_DBNAME}.* TO '${DO_MYSQL_USER}'@'localhost' IDENTIFIED BY '${DO_MYSQL_PASS}';"
+# ruby-mysql2 tests use the "test" db.
+mysqladmin --user=${DO_MYSQL_USER} --socket=${MYSQL_UNIX_PORT} create test

 "$@"