# Tables are not populating in the Database Query Browser

**URL:** <https://forum.inductiveautomation.com/t/tables-are-not-populating-in-the-database-query-browser/64976>\
**Category:** Ignition\
**Tags:** database\
**Created:** [October 8, 2022, 7:20pm UTC](https://forum.inductiveautomation.com/t/tables-are-not-populating-in-the-database-query-browser/64976 "2022-10-08T19:20:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![GeekyGearHead](https://avatars.discourse-cdn.com/v4/letter/g/e68b1a/32.png) [@GeekyGearHead](https://forum.inductiveautomation.com/u/GeekyGearHead)\
**Post date:** [October 8, 2022, 7:20pm UTC](https://forum.inductiveautomation.com/t/tables-are-not-populating-in-the-database-query-browser/64976/1 "2022-10-08T19:20:32Z")

</div>

Hi! I am trying to use the Database Query Browser connected to a MYSQL database. As you can see in the screenshot, I can return table information from the MYSQL database but the schema is not populating in the right hand pane. Any advice on how to get the tables in the "Sakila" instance of the MYSQL database to show up in the Schema browser?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/e/5eed333d889f204ef7f10367f5aa2706e77e294a.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [October 8, 2022, 7:32pm UTC](https://forum.inductiveautomation.com/t/tables-are-not-populating-in-the-database-query-browser/64976/2 "2022-10-08T19:32:12Z")

</div>

Are you looking in the right database?

![Database dropdown](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/6/f618e79a91e2ec66be1461c296532a898da7e29f.png)

Should that be 'sakila'?

---

<div class="post-metadata">

**Author:** ![GeekyGearHead](https://avatars.discourse-cdn.com/v4/letter/g/e68b1a/32.png) [@GeekyGearHead](https://forum.inductiveautomation.com/u/GeekyGearHead)\
**Post date:** [October 8, 2022, 8:32pm UTC](https://forum.inductiveautomation.com/t/tables-are-not-populating-in-the-database-query-browser/64976/3 "2022-10-08T20:32:30Z")

</div>

The MyMySQL database was showing connected but the URL for the actual database connection was incorrect. I changed the URL and it is working! Thanks for the reply... kinda new to this stuff and appreciate the help. Here is a screenshot of what I had to change to get it to work.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/c/9cac48fc77166084c7a356d2be08b2a66e148478.png) ... also a screenshot of the schema populated.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/76bc9f2410d7598935a710b81ff1efe760895587.png)

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [October 8, 2022, 8:37pm UTC](https://forum.inductiveautomation.com/t/tables-are-not-populating-in-the-database-query-browser/64976/4 "2022-10-08T20:37:42Z")

</div>

That would do it.  
It might be good practice to reference the DB name in the database connection.  
e.g., `db_conn_sakila`.