# PostgreSQL Data in MySQL Workbench with no tables

**URL:** <https://community.cdata.com/t/postgresql-data-in-mysql-workbench-with-no-tables/1073>\
**Category:** CData Drivers\
**Tags:** question, sql-gateway\
**Created:** [April 11, 2025, 8:18am UTC](https://community.cdata.com/t/postgresql-data-in-mysql-workbench-with-no-tables/1073 "2025-04-11T08:18:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![DuyNguyen](https://avatars.discourse-cdn.com/v4/letter/d/ac8455/32.png) [@DuyNguyen](https://community.cdata.com/u/DuyNguyen)\
**Post date:** [April 11, 2025, 8:18am UTC](https://community.cdata.com/t/postgresql-data-in-mysql-workbench-with-no-tables/1073/1 "2025-04-11T08:18:11Z")

</div>

Hi.

I am using CData SQL Gateway to query PostgreSQL data in MySQL workbench. MySQL workbench has successfully connected to PostgreSQL data source, but no table can be fetched.

Here is my error:

 ![cd9d6d82-202f-47b2-99b9-a79d61d236da.png](https://us1.discourse-cdn.com/cdata/original/2X/9/95b0eb09b09cf9c4b48d3f96f470f1aea7ba2c0d.png)

This is my CData PostgreSQL ODBC configuration:

 ![9849aa88-c3b8-4a35-99fb-e27e44a6e0cc.png](https://us1.discourse-cdn.com/cdata/original/2X/4/46f1d877df2fdbca3d6bbf2f0d1dc092c755c17b.png)

And this is my mysql remoting service configuration in CData SQL Gateway:

 ![69aa07f6-bdf0-4177-b361-80e45b448920.png](https://us1.discourse-cdn.com/cdata/original/2X/b/b48919cfccb17a7be6d11e34ba0efcac95d29c81.png)

This is my MySQL WorkBench connection configuration to the above “mysql remoting service”:

 ![4dab646f-dd12-4c96-9290-5306e574993f.png](https://us1.discourse-cdn.com/cdata/original/2X/c/c6a56eef43cf4a07186345c98d7e92f7add15a97.png)

How do I resolve this issue? Many thanks!

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [April 11, 2025, 12:43pm UTC](https://community.cdata.com/t/postgresql-data-in-mysql-workbench-with-no-tables/1073/2 "2025-04-11T12:43:37Z")

</div>

Hi ​ @DuyNguyen

The “Lost connection to MySQL server during query”&nbsp;error that you are encountering would typically indicate the connection between your MySQL client and database server has timed out. Essentially, this can occur in cases when it takes&nbsp;too long for the query to return data so the connection gets dropped.  
You can avoid the error by changing some Timeout values. If you’re an administrator for your MySQL server, MySQL documentation suggests increasing the _net\_read\_timeout_ or _connect\_timeout_ values on the server.  
&nbsp;  
Alternatively you can also try this&nbsp;in MySQL Workbench, by editing the SQL Editor preferences:  
In the application menu, select Edit \> Preferences \> SQL Editor. Look for the MySQL Session section and increase the DBMS connection read time out value.

 ![5811dd8b-63a8-4a7b-ad6f-006e2fc80365.png](https://us1.discourse-cdn.com/cdata/original/2X/7/7ba36d96ae82069ed8c1d2a524d064bf2b9e60d2.png)

The default value is 30 so try setting a higher value. Save the settings, quit&nbsp;MySQL Workbench and reopen the connection.

If issues persist even after the above suggestion, I would recommend you open a ticket with our support team [here](https://www.cdata.com/support/submit.aspx)&nbsp;and send over the Gateway logs along with additional details&nbsp;so they can look further into the matter.