Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Contributor

jline-sqlline-mysql-connector.tar.gz

Step1:

Download the attached tar file and untar it

tar -xvf jline_sqlline__mysql_connector.tar

Step2:

Syntax:

[root]# java -Djava.ext.dirs=/path/to/jline_sqlline__mysql_connector/ sqlline.SqlLine

Example:

[root@mi3 sqlline]# java -Djava.ext.dirs=/root/sqlline/jline-1.0/ sqlline.SqlLine

sqlline version 1.0.2 by Marc Prud'hommeaux

Step3:

Syntax:

sqlline> !connect jdbc:mysql://<mysql hostname>:<port>/<db> <username> <password>

Example:

sqlline> !connect jdbc:mysql://hostabc:3306/hue hue hue

Connecting to jdbc:mysql://mi1.openstacklocal:3306/hue

Connected to: MySQL (version 5.1.73)

Driver: MySQL-AB JDBC Driver (version mysql-connector-java-5.1.17-SNAPSHOT ( Revision: ${bzr.revision-id} ))

Autocommit status: true

Transaction isolation: TRANSACTION_REPEATABLE_READ

0: jdbc:mysql://mi1.openstacklocal:3306/hue>

9,480 Views
Comments
New Contributor

Bless you!!

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎03-14-2017 02:46 AM
Updated by:
 
Contributors
Top Kudoed Authors