# Enterprise Search MySQL native connector

**URL:** <https://discuss.elastic.co/t/enterprise-search-mysql-native-connector/327082>\
**Category:** Elastic Search\
**Tags:** docker, elastic-app-search\
**Created:** [March 6, 2023, 1:28pm UTC](https://discuss.elastic.co/t/enterprise-search-mysql-native-connector/327082 "2023-03-06T13:28:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sebastianboelling](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@sebastianboelling](https://discuss.elastic.co/u/sebastianboelling)\
**Post date:** [March 6, 2023, 1:28pm UTC](https://discuss.elastic.co/t/enterprise-search-mysql-native-connector/327082/1 "2023-03-06T13:28:09Z")

</div>

Hi,

I have an on-premise deployment of Enterprise Search 8.6.2. based on the docker compose example [Install Elasticsearch with Docker | Elasticsearch Guide [8.6] | Elastic](https://www.elastic.co/guide/en/elasticsearch/reference/current/docker.html#docker-compose-file)

I am trying out the native connector to MySQL and I am using the documentations [Native connectors | Elastic Enterprise Search documentation [8.6] | Elastic](https://www.elastic.co/guide/en/enterprise-search/8.6/native-connectors.html) and here [Elastic MySQL connector reference | Elastic Enterprise Search documentation [8.6] | Elastic](https://www.elastic.co/guide/en/enterprise-search/8.6/connectors-mysql.html)

But the sync is not working. Status is 'configured' - the initial sync seems not to work. I tried with different users (also the MySQL root) and on different VMs (also all together on the same VM).

I am a bit confused about the documentation . Is the MySQL native connector out of the box installed together with Enterprise Search if I use on-premise with docker compose (see above)? Or do I have to setup the connector manually as an additional component?

Best regards Sebastian

---

<div class="post-metadata">

**Author:** ![Sander\_Philipse](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sander_philipse/32/101890_2.png) [@Sander\_Philipse](https://discuss.elastic.co/u/Sander_Philipse)\
**Post date:** [March 6, 2023, 2:07pm UTC](https://discuss.elastic.co/t/enterprise-search-mysql-native-connector/327082/2 "2023-03-06T14:07:50Z")

</div>

Hi Sebastian,

For on-premises installations you will need to run a connector separately, and configure it to start in native method with mysql as one of the native service types so that it automatically picks up your native configuration. You can find the connector [here](https://github.com/elastic/connectors-python/) and instructions on how to run it in native mode [here](https://github.com/elastic/connectors-python/blob/main/docs/CONFIG.md) (scroll down to "Run the connector in native mode).

---

<div class="post-metadata">

**Author:** ![sebastianboelling](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@sebastianboelling](https://discuss.elastic.co/u/sebastianboelling)\
**Post date:** [March 7, 2023, 11:30am UTC](https://discuss.elastic.co/t/enterprise-search-mysql-native-connector/327082/3 "2023-03-07T11:30:20Z")

</div>

Hi @Sander_Philipse ,

ok, I've got the connector running. It's really easy if you're using the Docker Container. You can see how, if you're looking into the Makefile. Would be helpful for others to document this great option at [connectors-python/CONFIG.md at main · elastic/connectors-python · GitHub](https://github.com/elastic/connectors-python/blob/main/docs/CONFIG.md)

Regards

Sebastian

---

<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:** [April 4, 2023, 11:31am UTC](https://discuss.elastic.co/t/enterprise-search-mysql-native-connector/327082/4 "2023-04-04T11:31:20Z")

</div>

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