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:

mysql, bash, query, input, heredoc, trickmost, method, repeatedly, manually, login, semi, automate, queries, modify, adding, colon, typing, edit, user, password, username, flexible, yourpassword, eof, somedb, select, auctions, dynamic, quot, database, db, localhost, identified, piping, echo,

Latest Articles

  • Microsoft Teams Linux - Calendar Doesn't Work Missed Meetings!
  • Scanner not working in Linux Ubuntu Fedora Mint Debian over the network? Use sane-airscan!
  • How To Boot, Install and Run Windows 2000 on QEMU-KVM
  • bash cannot execute permission denied
  • Huion and Wacom Tablets How To Install in Linux Mint / Ubuntu and make the stylus work properly
  • ffmpeg how to cut certain parts of video out
  • ffmpeg how to concat and join two video clips
  • mencoder instead of ffmpeg to join or concatenate video files with different audio streams
  • Linux How To Stop Missing Drive from Halting Boot Process in fstab
  • How To Replace Audio Track of Video using ffmpeg
  • qemu-img convert formats vdi vmdk raw qcow2
  • Linux and Windows Dual Boot Crazy Time Issues
  • dynagen / dynamips 100% high CPU usage solution - how to set the idlepc value
  • How To Setup a Cisco CME (Cisco Manager Express) Virtual Router under Linux using dynamips and dynagen
  • Linux Mint Ubuntu Debian CentOS Dual Boot Install Issues
  • Linux Mint Ubuntu Debian Centos RHEL no sound solution
  • Linux Mint/Debian/Ubuntu/Centos Installer black grub screen and blank screen after trying to boot installer or main OS
  • Linux Mint Dual Boot Install Avoid Wiping our your Main C: drive /dev/sda MBR and EFI
  • QEMU-KVM soundhw deprecated how to enable sound in QEMU 4.x series
  • Virtualbox Error Cannot register the hard disk because a hard disk with UUID already exists solution