Script that reads php configuration file (that returns an array) and connects to a mysql database.

README.txt

To use mysql client on staging, devs need to ssh to the server, then "cat" the configuration file of the application to get the username / password / host.
The idea of this script is to read the configuration from the php application and use that information to connect to mysql using the mysql client in 1 command.

config.php

<?php
return [
  'db_name' => 'application',
  'db_user' => 'root',
  'db_password' => 'root',
  'db_host' => '127.0.0.1'
  ];

mysql_connect.sh

#
# Aid script to connect to mysql easly in different environments.
# It reads the application configuration file and uses it to connect to mysql.
#

sqluname=$(php -r '$var = include("config.php"); echo $var["db_user"];')
sqlpasswd=$(php -r '$var = include("config.php"); echo $var["db_password"];')
dbname=$(php -r '$var = include("config.php"); echo $var["db_name"];')
sqlhost=$(php -r '$var = include("config.php"); echo $var["db_host"];')

if [ -n "$sqlpasswd" ]; then
  /usr/bin/mysql -h$sqlhost -u $sqluname -p$sqlpasswd $dbname
else
  /usr/bin/mysql -h$sqlhost -u $sqluname $dbname 
fi