MySQL Bash Query to pipe input directly without using heredoc trick

Most of us know the heredoc method but what if you need a basic query done repeatedly and manually while working from bash?  It is a pain to manually type mysql and login each time. 

With this command below you can semi-automate those queries:

echo "use somedb; select * from auctions" | mysql -u root --password="yourpassword"

Just modify the above to suit your needs and you can add more queries by adding a semi-colon ; after each and just typing a new query.  Of course on the mysql command you will need to edit the user and password to suit your username and password.

Here is the longer heredoc version that is more flexible:


mysql -u user --password='yourpassword' << eof
use somedb;

select * from auctions;
eof

If you want to make the above more dynamic you could do this:

query="CREATE database $db;GRANT ALL on $db.* to $user@localhost IDENTIFIED by '$password'
"
mysql -u user --password='yourpassword' << eof
$query
eof

If you want to do the same thing with the piping you could make it like this:

query="CREATE database $db;GRANT ALL on $db.* to $user@localhost IDENTIFIED by '$password'
"

echo "$query" | mysql -u root --password="yourpassword"


Tags:

Latest Articles

  • PHP2Shell Patching, Migration and Vulnerability Guide With Solutions
  • Firefox PDF Does Not Display - Shows Desktop Or Other App Instead Solution
  • How To Convert HTML to Text Based PDF
  • How To Emulate Android in Linux
  • How to use KVM and GUI inside Docker
  • python spacey ERROR: No matching distribution found for thinc<8.4.0,>=8.3.12
  • Debian 11 security repo fixes due to EOL
  • MySQL vs MariaDB how to create a socket user tutorial
  • Ubuntu Linux Mint Desktop Dark Black Cannot See Solution
  • How to combine .txt ACLs without breaking things
  • How to ping all of Googlebot's IPs script
  • 'virtio0' uses a qcow2 feature which is not supported by this qemu version: QCOW version 3
  • Linux bash script to get the IP of a list of hostnames
  • How To Use Camera Webcam in Docker for OBS Studio etc...
  • Computer Server Won't Post Boot Or Enter BIOS Setup After Installing RAID SAS or GPU Card etc..
  • How To Test PHP Scripts from CLI with GET variables/query string
  • apt-cache how to see all available versions of a package in Debian Ubuntu Mint
  • Virtualbox VBox Guest-utils drag and drop files stops working with Windows VMs
  • How To Remove Ubuntu Netplan and Go Back to /etc/network/interfaces
  • How To Force Flash an AMD Instinct GPU To Another Model Using Debian Ubuntu Mint Linux