I want to use this script to run with Ansible. My requirements were to read the maximum connections in mysql server. Also I want to write the output from mysql client in to a file.
You can use
mysql -e "show status like 'max_used_connections';" Or you can use
mysql <<EOF tee /tmp/mysql_max.txt show variables like 'max_connections'; show status like 'max_used_connections'; EOF output
Logging to file '/tmp/mysql_max.txt' Variable_name Value max_connections 100 Variable_name Value Max_used_connections 10