SQWareProduction:mysql:etc:.profile

Exemple de .profile $gvsqw_MysBin/../etc/.profile:
Exemple de lignes a ajouter au .profile pour les users mysql.

Contenu du fichier:

#!/bin/bash
###################################################################
# SQWareProduction for Mysql module of dbSQWare
# 
# dbSQWare is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS for a PARTICULAR PURPOSE.  See the
# CGU/CGA for more details.
# 
# You should have received a copy of the CGU/CGA
# along with this program.  If not, see <http://www.dbsqware.com/licenses/>.
# 
# For information : contact@dbsqware.com or www.dbsqware.com
###################################################################
## @Synopsis	template .profile for unix users Mysql
## @Copyright	Copyright 2007-2025, dbSQWare (www.dbsqware.com)

export LANG='en_US.UTF-8'

export MYSQL_SID=MYS_XXXX_YYY

#dbSQWare
export gvsqw_Env='PRD'
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
then
	. $gvsqw_MysBin/../etc/.profile_confort
fi

###################################################################
###################################################################
## Multi instance

export PATH='/cygdrive/d/Program Files/MariaDB 10.3/bin':$PATH
export LD_LIBRARY_PATH='/cygdrive/d/Program Files/MariaDB 10.3/lib':$LD_LIBRARY_PATH
export LANG='en_US.UTF-8'

lvsqw_Instance=$1
case $lvsqw_Instance in
MAR_W103_PRD)
	export MYSQL_SID=$lvsqw_Instance
    export PATH='/cygdrive/d/Program Files/MariaDB 10.3/bin':$PATH
    export LD_LIBRARY_PATH='/cygdrive/d/Program Files/MariaDB 10.3/lib':$LD_LIBRARY_PATH
    export MYSQL_PORT=3306
    ;;
MAR_W104_PRD)
	export MYSQL_SID=$lvsqw_Instance
    export PATH='/cygdrive/d/Program Files/MariaDB 10.4/bin':$PATH
    export LD_LIBRARY_PATH='/cygdrive/d/Program Files/MariaDB 10.4/lib':$LD_LIBRARY_PATH
    export MYSQL_PORT=3307
    ;;
*)
    export MYSQL_SID="NoSID"
    export MYSQL_PORT=3300
    ;;
esac

#dbSQWare
export gvsqw_Env='PRD'
export gvsqw_MysBin=$HOME/SQWareProduction/mysql/bin
lvsqw_IsTerminal=$(tty 2>&1 >/dev/null;echo $?)
if [ "$lvsqw_IsTerminal" = "0" ] && [ -r $gvsqw_MysBin/../etc/.profile_confort ]
then
	. $gvsqw_MysBin/../etc/.profile_confort
fi