# Installing logstash jdbc plugin
**URL:** https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885
**Category:** Logstash
**Created:** [April 13, 2018, 12:12am UTC](https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885 "2018-04-13T00:12:09Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@squanchydata](https://discuss.elastic.co/u/squanchydata)
#### Post date: [April 13, 2018, 12:12am UTC](https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885/1 "2018-04-13T00:12:09Z")
In order for me to link my mysql database with elasticsearch, I need the jdbc plugin with logstash.
Where/how do I install this plugin and how do I use it?
---
### Author:  [@yaauie](https://discuss.elastic.co/u/yaauie)
#### Post date: [April 13, 2018, 12:24am UTC](https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885/2 "2018-04-13T00:24:36Z")
The JDBC input plugin is installed by default with modern versions of Logstash, but you may need to install a _driver_.
To do so, download the appropriate JDBC driver to the local filesystem of your Logstash host, and point to it in your pipeline configuration:
The MySQL driver is available for download [here](https://dev.mysql.com/downloads/connector/j/5.1.html).
Once it is on the Logstash machine's filesystem, you can reference it with the JDBC Input Plugin's [`jdbc_driver_library`](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-jdbc_driver_library) and [`jdbc_driver_class`](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-jdbc_driver_class) directives:
```auto
input {
jdbc {
"jdbc_driver_library" => "/path/to/mysql/driver.jar"
"jdbc_driver_class" => "com.mysql.jdbc.Driver"
}
}
```
---
### Author:  [@squanchydata](https://discuss.elastic.co/u/squanchydata)
#### Post date: [April 13, 2018, 12:37am UTC](https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885/3 "2018-04-13T00:37:40Z")
Thank you. And the jdbc connection string should be pointing toward my localhost of mysql?
---
### Author:  [@yaauie](https://discuss.elastic.co/u/yaauie)
#### Post date: [April 13, 2018, 1:44am UTC](https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885/4 "2018-04-13T01:44:09Z")
If your mysql is hosted on the same machine, and is bound to local interfaces, then yes.
If your machine is hosted on a different machine, the connection string will need to reference it.
I found the MySQL docs for it here: [https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html](https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 11, 2018, 1:44am UTC](https://discuss.elastic.co/t/installing-logstash-jdbc-plugin/127885/5 "2018-05-11T01:44:22Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.