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

Announcements
Join us in Bucharest on Sept 18th 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