Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tsystem for connection to mysql server and list all databases

Hi, with TOS for big data 6.3.0, I'am using tsystem to connect to a local server to list all databases.
this is my simple command  "mysql -u root ;show databases" it's doesn't work
HELP Please!!!
Labels (2)
4 Replies
Anonymous
Not applicable
Author

of course i'am using linux(ubuntu)
vapukov
Master II
Master II

of course this "simple command" just wrong 0683p000009MACn.png
correct command:
mysql -u root -e 'show databases;'
Anonymous
Not applicable
Author

it gives me this result : 
connecting to socket on port 3643
connected
mysql  Ver 14.14 Distrib 5.5.54, for debian-linux-gnu (x86_64) using readline 6.3
Copyright (c) 2000, 2016, 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
  -?, --help          Display this help and exit.
  -I, --help          Synonym for -?
  --auto-rehash       Enable automatic rehashing. One doesn't need to use
                      'rehash' to get table and field completion, but startup
                      and reconnecting may take a longer time. Disable with  

To see the whole post, download it here
OriginalPost.pdf
vapukov
Master II
Master II

it mean:

tSystem work
You make more mistake when copy command 

please attach screenshots with settings, it make more easy to help