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

  • Enable AMDGPU Linux Driver
  • apache symlinks denied even with followsymlinks
  • chown how to change ownership on a symlink
  • how to use ifplugd in Linux to execute a command or script when a NIC cable is unplugged or plugged in
  • dd how to backup and restore disk images including compression with gzip
  • mpv / mplayer with Radeon / AMD GPU Video Card Driver enable VDPAU GPU Accelerated Video Decoding
  • Wordpress Reset Blog User Password from MySQL Using Linux Bash and not PHPMyadmin
  • Ubuntu Linux Mint Debian xorg performance and tear-free tuning for AMD Radeon Based Cards
  • Centos 7 Stopped and Disabled Firewalld and ports still blocked
  • MariaDB / MySQL Reset Root Forgotten Password on Centos 7
  • Centos 7 How to install Mysql/Mariadb
  • PHP 7.2, Apache and Centos 7 How To Install
  • Ubuntu Debian Linux Mint r8169 r8168 Network Driver Problem and Solution
  • Linux 3D Performance benchmarks with glxgears 59-60fps solution
  • How To Install Asterisk 16 17 on Debian Ubuntu Linux
  • Linux Ubuntu Debian Centos How To Make a Bootable Windows 7, 8, 10, 2016, 2019 Server USB from ISO
  • How To Restore Windows MBR Bootsector from Linux using syslinux
  • Linux Ubuntu Cannot Print Large Images
  • Cannot Print PDF Solution and Howto Resize
  • Linux Console Login Screen TTY Change Message