# JDBC Connect Error

**URL:** https://discuss.elastic.co/t/jdbc-connect-error/128139
**Category:** Logstash
**Created:** [April 16, 2018, 8:52am UTC](https://discuss.elastic.co/t/jdbc-connect-error/128139 "2018-04-16T08:52:37Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![seungtae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seungtae/32/71413_2.png) [@seungtae](https://discuss.elastic.co/u/seungtae)
#### Post date: [April 16, 2018, 8:52am UTC](https://discuss.elastic.co/t/jdbc-connect-error/128139/1 "2018-04-16T08:52:37Z")

</div>

> How can I sove this Error..? using password?? Is there an option for using password in the Reference?
> 
> Error:

[ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<Sequel::DatabaseConnectionError: Java::JavaSql::SQLException: Access denied for user 'root'@'1.247.39.243' (using password: YES)\>, :backtrace=\>...

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [April 16, 2018, 11:38am UTC](https://discuss.elastic.co/t/jdbc-connect-error/128139/2 "2018-04-16T11:38:00Z")

</div>

Are you specifying a password in your jdbc input? Is it the right one? What does your configuration look like?

---

<div class="post-metadata">

### Author: ![seungtae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seungtae/32/71413_2.png) [@seungtae](https://discuss.elastic.co/u/seungtae)
#### Post date: [April 17, 2018, 12:11am UTC](https://discuss.elastic.co/t/jdbc-connect-error/128139/3 "2018-04-17T00:11:30Z")

</div>

@magnusbaeck Thank you for your reply.

Yes.. password is correct. My configuration is this :

```
if(![tcpCid]){
		jdbc_streaming {
			jdbc_connection_string => "jdbc:mysql://182.162.136.33:3306/Jecheon"
			jdbc_driver_library => "C:\logstash-6.2.3\logstash-6.2.3\lib\mysql-connector-java-5.1.46\mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar"
	
			jdbc_user => "root"
			jdbc_password => "jkcore997300**"

			statement => "SELECT CID FROM TB_PVC WHERE LORA_DEVID = :parsedSr"
			target => "matchingCid"

			jdbc_driver_class => "com.mysql.jdbc.Driver"
		}
	}
```

---

<div class="post-metadata">

### Author: ![seungtae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/seungtae/32/71413_2.png) [@seungtae](https://discuss.elastic.co/u/seungtae)
#### Post date: [April 17, 2018, 1:05am UTC](https://discuss.elastic.co/t/jdbc-connect-error/128139/4 "2018-04-17T01:05:06Z")

</div>

@magnusbaeck Oh.. I'm so sorry. Password isn't correct.. Thank you

---

<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: [May 15, 2018, 1:05am UTC](https://discuss.elastic.co/t/jdbc-connect-error/128139/5 "2018-05-15T01:05:12Z")

</div>

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