Created on 03-14-2017 02:46 AM - edited 09-16-2022 01:39 AM
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:
sqlline> !connect jdbc:mysql://<mysql hostname>:<port>/<db> <username> <password>
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>
Created on 08-02-2018 07:29 PM
Bless you!!