CODEWITHSUNDEEP
mysqlubuntuselectcommand-line
Ryan Gillies
Ryan Gillies

Reputation: 463

mysql command line not outputting results

I'm baffled as to where I'm going wrong with the following mysql command in my bash script to get a SELECT statement out in HTML format.

#!/bin/bash

dbhost="localhost"
dbname="unicentaopos"
dbuser="user"
dbpass="pass"

mysql -h $dbhost -u $dbuser -p $dbpass -H -e "SELECT NOW();" $dbname > /home/imperial/.scripts/test.txt

Everything is identical to my script, except for the credentials for obvious reasons. I have also tried hard coding the vars into the command - same results.

I cannot see anything wrong with what I've done, but the text file produced just contains mysql usage options:

mysql  Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using  EditLine wrapper
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Usage: mysql [OPTIONS] [database]
  -?, --help          Display this help and exit.
  -I, --help          Synonym for -?
etc etc etc etc.....

Can anyone tell me what's wrong?

Upvotes: 1

Views: 230

Answers (1)

Zubair
Zubair

Reputation: 11

is the dbhost variable accessed correctly? #dbhost -> $dbhost

Upvotes: 1

Related Questions