# Unable to connect to remote MySQL DB and browse API Docs

**URL:** <https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880>\
**Category:** Connecting to SQL\
**Created:** [December 3, 2015, 3:52pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880 "2015-12-03T15:52:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrvipinkashyap](https://avatars.discourse-cdn.com/v4/letter/m/977dab/32.png) [@mrvipinkashyap](https://community.dreamfactory.com/u/mrvipinkashyap)\
**Post date:** [December 3, 2015, 3:52pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880/1 "2015-12-03T15:52:04Z")

</div>

I have configured MySQL database in “Services” tab based upon this guide here:  
[https://wiki.dreamfactory.com/DreamFactory/Tutorials/Connecting\_to\_SQL](https://wiki.dreamfactory.com/DreamFactory/Tutorials/Connecting_to_SQL)  
But it doesn’t list the tables in either “Schema” or “Data” tabs for that service.

Another issue which I am not sure is related to this is that I am not able to browse through “API Docs”. Clicking on any of the buttons (eg. Show/Hide, List Operations etc.) doesn’t expand or collapse the list as it usually does.  
This is working fine in Bitnami on local machine.

Any help is appreciated.  
Thanks.

---

<div class="post-metadata">

**Author:** ![juniorconte](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/juniorconte/32/1007_2.png) [@juniorconte](https://community.dreamfactory.com/u/juniorconte)\
**Post date:** [December 3, 2015, 6:03pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880/2 "2015-12-03T18:03:50Z")

</div>

Hello, I suspect they are the credentials for database access. Have you ever connected to the same database from your local machine?

---

<div class="post-metadata">

**Author:** ![mrvipinkashyap](https://avatars.discourse-cdn.com/v4/letter/m/977dab/32.png) [@mrvipinkashyap](https://community.dreamfactory.com/u/mrvipinkashyap)\
**Post date:** [December 3, 2015, 6:10pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880/3 "2015-12-03T18:10:49Z")

</div>

Yes. I have double checked the credentials. They are correct.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [December 3, 2015, 6:16pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880/4 "2015-12-03T18:16:41Z")

</div>

This is most likely a connection issue. What is your connection string?  
If you have access to your log file it will provide more insight as well. It’s in the storage/logs folder within the DreamFactory root.

---

<div class="post-metadata">

**Author:** ![mrvipinkashyap](https://avatars.discourse-cdn.com/v4/letter/m/977dab/32.png) [@mrvipinkashyap](https://community.dreamfactory.com/u/mrvipinkashyap)\
**Post date:** [December 3, 2015, 6:26pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880/5 "2015-12-03T18:26:00Z")

</div>

Here is my connection string:  
mysql:host=ip\_address;port=3306;dbname=db\_name

I am not sure how can I access my log details. Just to clarify for you to help me better, I am running it on dreamfactory instance not on local or private server.

---

<div class="post-metadata">

**Author:** ![formerstaff](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/formerstaff/32/1133_2.png) [@formerstaff](https://community.dreamfactory.com/u/formerstaff)\
**Post date:** [December 3, 2015, 6:29pm UTC](https://community.dreamfactory.com/t/unable-to-connect-to-remote-mysql-db-and-browse-api-docs/1880/6 "2015-12-03T18:29:28Z")

</div>

if your instance is hosted on [enterprise.dreamfactory.com](https://enterprise.dreamfactory.com) then you do not have access to the logs. The dreamfactory support team can check for you if you provide your instance URL.

The most likely issue is that your mysql server is not allowing connections from the DreamFactory server. The IP for the hosted system is 52.4.195.0 if you would like to try changing your mysql server setup.