CONNECT_TO_MYSQL_AS_USER 1.15 KB
#!/usr/bin/env bash

# Si execution directe depuis le repertoire data/ (bind du repertoire docker)
# => on rappelle ce meme script avec le CLI docker puis on exit
[ -f ../DOCKER_LABINVENT_START ] && docker exec -it labinvent $0
[ -f ../DOCKER_LABINVENT_START ] && exit
# Execution SANS docker, ou bien AVEC docker depuis le conteneur
echo "IN $(pwd)"





# Si fichier install/ENV.sh existe, alors mode SANS docker
[ -f install/ENV.sh ] && source install/ENV.sh

echo $MYSQL_USER
echo $MYSQL_PASSWORD
echo $MYSQL_HOST

#echo $MYSQL_PORT #127.0.0.1:3307
#MYSQL_PORT=$(echo "$MYSQL_PORT" | cut -d':' -f 2)
#echo $MYSQL_PORT #3307

# PROD table : labinvent
mysql $MYSQL_DATABASE -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD

# TEST table : test_labinvent
#mysql test_${MYSQL_DATABASE} -h $MYSQL_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD

#mysql test_labinvent -u labinvent_user -plabinvent --host='db'
#mysql labinvent -u labinvent_user -plabinvent --host='db'
#mysql $MYSQL_DATABASE -h 127.0.0.1 -u $MYSQL_USER -p$MYSQL_PASSWORD
#mysql -h 127.0.0.1 -u $MYSQL_USER -P $MYSQL_PORT --protocol=tcp -p$MYSQL_PASSWORD
#mysql -h 127.0.0.1 -u $MYSQL_USER -P $MYSQL_PORT -p$MYSQL_PASSWORD