# How to configure the jdbc input plugin for mysql

**URL:** <https://discuss.elastic.co/t/how-to-configure-the-jdbc-input-plugin-for-mysql/201991>\
**Category:** Logstash\
**Created:** [October 2, 2019, 3:30pm UTC](https://discuss.elastic.co/t/how-to-configure-the-jdbc-input-plugin-for-mysql/201991 "2019-10-02T15:30:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![alejandro\_del\_rey](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alejandro_del_rey/32/55258_2.png) [@alejandro\_del\_rey](https://discuss.elastic.co/u/alejandro_del_rey)\
**Post date:** [October 2, 2019, 3:30pm UTC](https://discuss.elastic.co/t/how-to-configure-the-jdbc-input-plugin-for-mysql/201991/1 "2019-10-02T15:30:41Z")

</div>

HI.

I work in windows, and i need use input plugin for mysql, i have this:

* * *

jdbc {  
jdbc\_connection\_string =\> "jdbc:mysql://127.0.0.1:3306/ruby"  
jdbc\_user =\> "ale"  
jdbc\_password =\> "ale"

#DRIVER  
jdbc\_driver\_library =\> "E:\Bacardi\mysql-connector-java-5.1.39.jar"  
jdbc\_driver\_class =\> "com.mysql.cj.jdbc.Driver"

#SQL  
statement =\> "SELECT \* FROM prueba"  
#jdbc\_paging\_enabled =\> "true"  
#jdbc\_page\_size =\> "50000"  
}

* * *

but i have this error Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc\_driver\_library?

I tried:

```
#jdbc_driver_class => "com.mysql.cj.jdbc.Driver"

```

#jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
#jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"

but it still gives me the same error. please someone help me?

Sorry my English. thnks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 30, 2019, 3:30pm UTC](https://discuss.elastic.co/t/how-to-configure-the-jdbc-input-plugin-for-mysql/201991/2 "2019-10-30T15:30:53Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.