How to Run MySQL/MariaDB Queries Directly from the Linux Command Line

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.95/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Gabriel Cánepa

Gabriel Cánepa is a GNU/Linux sysadmin and web developer from Villa Mercedes, San Luis, Argentina. He works for a worldwide leading consumer product company and takes great pleasure in using FOSS tools to increase productivity in all areas of his daily work.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

You may also like...

3 Responses

  1. Bernt B says:

    Search for how to use the mysql_config_editor command. It stores the data encrypted.

    You set it up with:

    # mysql_config_editor set --login-path=myserver --host=dbserver.foo.com --user=adam -p
    

    Then you can do:

    alias sqlcmd='mysql --login-path=myserver  -Dmydbname  --execute'
    

    And finally:

    sqlcmd 'DESC table'
    
  2. LempStacker says:

    Maybe we can create a file name ‘.my.cnf’ under user home directory, add mysql user, password in it, like this
    [client]
    user=USERNAME
    password=USERPASSWD

    then change its mode as 600, so we can use command ‘mysql’ directly without set parameter ‘-p’, and password prompt would not appear.

  3. Tom-Erik Paulsen says:

    Wow , someone should make a tutorial on how to make a READ ONLY user for that tutorial. Even if the password is prompted, newcomers would easily add the root password to a script and pat themselves on the back.

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *