From de587bff11da8e3f856db17e2ba17ab95001ef66 Mon Sep 17 00:00:00 2001 From: gumi Date: Mon, 5 Sep 2016 14:04:41 -0400 Subject: add --host in mysql calls --- localserver/givegm.sh | 4 ++-- localserver/initdb.sh | 6 +++--- localserver/updatedb.sh | 2 +- 3 files changed, 6 insertions(+), 6 deletions(-) diff --git a/localserver/givegm.sh b/localserver/givegm.sh index c1a9c28..1350522 100755 --- a/localserver/givegm.sh +++ b/localserver/givegm.sh @@ -2,7 +2,7 @@ ID="$1" if [[ -z "${ID}" ]]; then - mysql -u evol -pevol evol -e "update login set group_id=99 where account_id=2000000;" + mysql --host=127.0.0.1 -u evol -pevol evol -e "update login set group_id=99 where account_id=2000000;" else - mysql -u evol -pevol evol -e "update login set group_id=99 where account_id=${ID} or userid='${ID}';" + mysql --host=127.0.0.1 -u evol -pevol evol -e "update login set group_id=99 where account_id=${ID} or userid='${ID}';" fi diff --git a/localserver/initdb.sh b/localserver/initdb.sh index d7625e3..7f868bd 100755 --- a/localserver/initdb.sh +++ b/localserver/initdb.sh @@ -7,14 +7,14 @@ cd ../../server-data/sql-files echo Creating db and user... echo Enter mysql root password: -mysql --force -u root -p <./init.sql +mysql --force --host=127.0.0.1 -u root -p <./init.sql result=$? if [ "$result" != 0 ]; then echo Password failed. Trying with sudo... - sudo mysql --force -u root <./init.sql + sudo mysql --force --host=127.0.0.1 -u root <./init.sql fi -export CMD="mysql -u evol -pevol evol" +export CMD="mysql --host=127.0.0.1 -u evol -pevol evol" echo Creating tables... $CMD /dev/null) export SQLDIR="../../server-data/sql-files/upgrades" -export CMD="mysql -u evol -pevol evol" +export CMD="mysql --host=127.0.0.1 -u evol -pevol evol" function run { echo "Running $1" -- cgit v1.2.3-70-g09d2