topic Re: tsystem for connection to mysql server and list all databases in Talend Studio

tsystem for connection to mysql server and list all databases

Anonymous — Sat, 16 Nov 2024 09:58:20 GMT

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!!!

Re: tsystem for connection to mysql server and list all databases

Anonymous — Thu, 23 Mar 2017 14:45:10 GMT

of course i'am using linux(ubuntu)

Re: tsystem for connection to mysql server and list all databases

vapukov — Thu, 23 Mar 2017 20:57:36 GMT

of course this "simple command" just wrong
correct command:

mysql -u root -e 'show databases;'

Re: tsystem for connection to mysql server and list all databases

Anonymous — Fri, 24 Mar 2017 08:56:53 GMT

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

Re: tsystem for connection to mysql server and list all databases

vapukov — Fri, 24 Mar 2017 14:36:23 GMT

it mean:

tSystem work
You make more mistake when copy command

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