Enter Zabbix DB, one-liner without password in history

Script:
Install:
curl -s "https://catonrug.blogspot.com/feeds/posts/default/5019307243605646752?alt=json" | jq -r '.entry|.content|."$t"' | sudo base64 --decode > /usr/bin/enter_zabbix_db
Set executable:
chmod +x /usr/bin/enter_zabbix_db
Using alias:
alias enter_zabbix_db='mysql -h$(grep "^DBHost" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//") -u$(grep "^DBUser" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//") -p$(grep "^DBPassword" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//") $(grep "^DBName" /etc/zabbix/zabbix_server.conf|sed "s/^.*=//")'

No comments: