# Error in cliente with MySQL

**URL:** <https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943>\
**Category:** Ignition\
**Tags:** database\
**Created:** [January 17, 2019, 2:56pm UTC](https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943 "2019-01-17T14:56:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sheko29](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sheko29/32/25082_2.png) [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\
**Post date:** [January 17, 2019, 2:56pm UTC](https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943/1 "2019-01-17T14:56:59Z")

</div>

Hello, I’m having a problem with my client…let me explain… in the ignition designer I inserted a table binding to my server in mysql and i can visualize the properties we add in mysql… the problem begin when the client is opened, because the table shows that it isn’t binded to a database…

designer:

 ![imagen](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/2ffcfab1c038af157580f54be0ac2aaf6576b8b1.png)

Client:

 ![imagen](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c33a1d51d26ee8f1c0b34c187f3820a253d95a39.png)

I hope someone knows why it happens and please helps me 🤗

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [January 17, 2019, 3:00pm UTC](https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943/2 "2019-01-17T15:00:33Z")

</div>

If your binding is not a named query, but a typed SQL query then you will have two options:

1. convert it to a named query
2. Enable Legacy Database Access under Project-\>Properties-\>Client-\>Permissions

---

<div class="post-metadata">

**Author:** ![Sheko29](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sheko29/32/25082_2.png) [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\
**Post date:** [January 17, 2019, 4:11pm UTC](https://forum.inductiveautomation.com/t/error-in-cliente-with-mysql/21943/3 "2019-01-17T16:11:16Z")

</div>

this change in the project properties completely solve my problem. thank you very much!