MySQL show current connection info Hostname and Port Number ?

Ekran Resmi 2017-10-14 18.16.57

If you want to know the port number of your local host on which Mysql is running you can use this query on MySQL Command line client

SHOW VARIABLES WHERE Variable_name = 'port';

If you want to know the hostname of your Mysql you can use this query on MySQL Command line client

SHOW VARIABLES WHERE Variable_name = 'hostname';

Error Message:

dbc.jtds 1.2.6 Driver is not the driver which is used for MySQL connection. You have to download for example mysql-connector-java-5.1.7 jar file to get the MySQL connection working.Please download the jar file which is compatible with your mysql version.

  • Unzip the driver, giving you a  “ ….  .jar” file.
  • Open SQL Developer and navigate to “Tools > Preferences > Database > Third Party JDBC Driver”.

then connect your user.

Ekran Resmi 2017-10-14 18.30.09

 

 

 

Hits: 1

Leave a Reply

Your email address will not be published. Required fields are marked *