# Natural and MySQL

**URL:** <https://techcommunity.softwareag.com/t/natural-and-mysql/101185>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux\
**Created:** [August 10, 2012, 3:27pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185 "2012-08-10T15:27:23Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 10, 2012, 3:27pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/1 "2012-08-10T15:27:23Z")

</div>

Natural can access MySQL database?  
With DDM? or ODBC?

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [August 10, 2012, 5:12pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/2 "2012-08-10T17:12:35Z")

</div>

The only database supported natively is Adabas. You’ll need Entire Access for ODBC support.

---

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 10, 2012, 7:53pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/3 "2012-08-10T19:53:47Z")

</div>

I found  
thank you

---

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 10, 2012, 8:54pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/4 "2012-08-10T20:54:16Z")

</div>

I install MySQL 5.5.25 and Natural.

I create an odbc to connect to mysql with name MYSQLNAT.

I insert in Entire Access the new ID 80 to SQL to connect ODBC:MYSQLNAT

In Natural a create new DDM and select 80/SQL and need name/password but always return error name/password

but this name/password is ok in mysql workbench.

Any idea?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [August 10, 2012, 10:10pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/5 "2012-08-10T22:10:15Z")

</div>

Where did you get Entire Access from ?

> [@Claudio Muller](#):
>
> I insert in Entire Access the new ID 80 to SQL to connect ODBC:MYSQLNAT

sounds like you talk about defining a database in the Natural Parameter module, but not Entire Access

---

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 10, 2012, 10:15pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/6 "2012-08-10T22:15:45Z")

</div>

understood  
I have to buy the Entire Access

and he not only set the parameters …

right?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [August 10, 2012, 11:04pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/7 "2012-08-10T23:04:49Z")

</div>

Exactly, Entire Access is an add-on which is not part of the community edition.

---

<div class="post-metadata">

**Author:** ![Claudio\_Muller](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudio_muller/32/518_2.png) [@Claudio\_Muller](https://techcommunity.softwareag.com/u/Claudio_Muller)\
**Post date:** [August 11, 2012, 5:03pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/8 "2012-08-11T17:03:44Z")

</div>

it is only paid?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [August 11, 2012, 6:26pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/9 "2012-08-11T18:26:14Z")

</div>

Yes.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:02pm UTC](https://techcommunity.softwareag.com/t/natural-and-mysql/101185/10 "2021-04-02T15:02:17Z")

</div>


