# Using 3rd party db-manager

**URL:** <https://community.kinsta.com/t/using-3rd-party-db-manager/658>\
**Category:** Application Support\
**Created:** [May 2, 2021, 8:48pm UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658 "2021-05-02T20:48:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Didou\_Schol](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/didou_schol/32/155_2.png) [@Didou\_Schol](https://community.kinsta.com/u/Didou_Schol)\
**Post date:** [May 2, 2021, 8:48pm UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658/1 "2021-05-02T20:48:53Z")

</div>

I’m trying to use a 3rd party database manager like [Dbeaver](https://dbeaver.io/download/) but I can’t seem to be able to connect. I’m using `localhost:3306` to connect to, and `root` as the username. I don’t remember setting a password for the server, but I’ve found Privileges in Adminer, which lists a password but still doesn’t work.

I’ve found a few posts here from folks that seem to have their password somehow and can import large files directly into Docker, so I assume that it’s possible.

I want to use Dbeaver to do more visual table JOINs.

---

<div class="post-metadata">

**Author:** ![michael](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/michael/32/31_2.png) [@michael](https://community.kinsta.com/u/michael)\
**Post date:** [May 3, 2021, 4:11pm UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658/2 "2021-05-03T16:11:13Z")

</div>

Hi @Didou_Schol ! Thanks for joining us here. Welcome!

As we’re using Docker here, you’ll need to be able to connect to the Docker instance. It’ll require a bit of configuration to use with Docker. [This is a good place to start on that](https://docs.docker.com/network/network-tutorial-host/). I hope that helps!

---

<div class="post-metadata">

**Author:** ![nemanjac](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/nemanjac/32/400_2.png) [@nemanjac](https://community.kinsta.com/u/nemanjac)\
**Post date:** [May 4, 2021, 3:42pm UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658/3 "2021-05-04T15:42:29Z")

</div>

@Didou_Schol I don’t believe your port would be 3306.  
To avoid issues with local ports your outbound port would be different.

Run `docker ps | grep devkinsta_db`  
This will give a result like

```auto
fd5885c3b91c mariadb:10.5.5 "docker-entrypoint.s…" 7 weeks ago Up 5 minutes 0.0.0.0:15100->3306/tcp devkinsta_db

```

Mind the part where it says `0.0.0.0:15100->3306/tcp`  
Here you can see your outbound port and local port  
In this case 15100 on your local machine is tunneled to 3306 on your docker container.

Your configuration will use 127.0.0.1 for the host, root for username, the password you already got.  
The missing link is port, which you can discover like mentioned above.

Cheers,  
Nemanja

---

<div class="post-metadata">

**Author:** ![Didou\_Schol](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/didou_schol/32/155_2.png) [@Didou\_Schol](https://community.kinsta.com/u/Didou_Schol)\
**Post date:** [May 6, 2021, 7:24am UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658/4 "2021-05-06T07:24:29Z")

</div>

Thanks @nemanjac and @michael for your replies!

After getting the port (15100) I had another attempt, but couldn’t quite figure out what my password was. I didn’t really remember setting one. After a lot of attempts on password that I _might_ have used 3 months ago I decided to settle for just access to the database that I currently needed. I looked in the wp-config.php file for the credentials and lo and behold, the credentials used there are for ALL databases. Password is not something I would have set manually.

Short story, I have access thanks to you guys and can now see my tables as I wanted. 😃

---

<div class="post-metadata">

**Author:** ![michael](https://sea2.discourse-cdn.com/flex020/user_avatar/community.kinsta.com/michael/32/31_2.png) [@michael](https://community.kinsta.com/u/michael)\
**Post date:** [May 7, 2021, 4:20pm UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658/5 "2021-05-07T16:20:41Z")

</div>

Apologies as I totally forgot about this guide here! For anyone else that sees this, check out our guide on [connecting with database tools](https://kinsta.com/knowledgebase/devkinsta/database-tools/)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/kinsta/original/2X/8/80f8c4e56fecc02327a0964e6bf63a716483529f.png) [@system](https://community.kinsta.com/u/system)\
**Post date:** [May 10, 2021, 4:21pm UTC](https://community.kinsta.com/t/using-3rd-party-db-manager/658/6 "2021-05-10T16:21:28Z")

</div>

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
