# Try to connect database of shopware 6 but facing issue

**URL:** <https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347>\
**Category:** Installation / Getting Started (EN)\
**Created:** [9. Juli 2019 um 10:06 UTC](https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347 "2019-07-09T10:06:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rizwan](https://avatars.discourse-cdn.com/v4/letter/r/bcef8e/32.png) [@Rizwan](https://forum.shopware.com/u/Rizwan)\
**Post date:** [9. Juli 2019 um 10:06 UTC](https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347/1 "2019-07-09T10:06:55Z")

</div>

Hello,

I have installed Shopware 6 in VM machine.It is successfully installed with this link Frontend :&nbsp;[http://192.168.33.10](http://192.168.33.10/)&nbsp;Backend :&nbsp;[http://192.168.33.10/admin#/login](http://192.168.33.10/admin#/login)&nbsp;  
now i am trying to connect database but i what exact url to connect database because there is no link define in vagrant docs&nbsp;

i have also&nbsp; installed shopware 5 in VM machine and this database url is&nbsp;[http://192.168.33.10/](http://192.168.33.10/)adminer.php but shopware 6 has not open adminer.php or adminer so how can i&nbsp; connect to database and also i want to connect with sqlyog so what configuration would i do to connect SQLyog

MYSQL:

mysql host address: localhost

user : root

password: password

database: shopware

SSH:  
ssh host address: [http://192.168.33.10/](http://192.168.33.10/)

user : root

password: password

One more thing i want to share i have changed the root password using cli

mysql -u root -p  
and i have mentioned this password&nbsp; demo1234  
so what will&nbsp;my new configuration?

&nbsp;

Thanking you in advance&nbsp;&nbsp;

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![wontfix](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@wontfix](https://forum.shopware.com/u/wontfix)\
**Post date:** [9. Juli 2019 um 11:10 UTC](https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347/2 "2019-07-09T11:10:54Z")

</div>

adminer is not part of shopware, you need to install it yourself.

---

<div class="post-metadata">

**Author:** ![Rizwan](https://avatars.discourse-cdn.com/v4/letter/r/bcef8e/32.png) [@Rizwan](https://forum.shopware.com/u/Rizwan)\
**Post date:** [9. Juli 2019 um 11:24 UTC](https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347/3 "2019-07-09T11:24:58Z")

</div>

Firstly Thanks to give feedback&nbsp;&nbsp;and&nbsp;  
OK i understood your&nbsp;point…&nbsp;but i am also trying to connect database using SQLyog but facing authentication issue. I have mentioned the mysql and SSH details which i insert for configured but facing error .

I can access the database using CLI. All tables will appear there tables count 152&nbsp;

but i want to configure this Database with SQLyog

Thanking you in advance

---

<div class="post-metadata">

**Author:** ![wontfix](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@wontfix](https://forum.shopware.com/u/wontfix)\
**Post date:** [9. Juli 2019 um 11:36 UTC](https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347/4 "2019-07-09T11:36:10Z")

</div>

i dont know SQLyog, so you have to read its documentation on that.  
(quick glance shows its a binary for ms-windows? in that case you propably need to allow direct mysql connections from outside, also for the mysql user…)

FWIW, heres how i install adminer on our (debian/ubuntu) vm:

```
mkdir /srv/adminer
curl -Lo /srv/adminer/index.php https://github.com/vrana/adminer/releases/download/v4.7.1/adminer-4.7.1.php
tee /etc/apache2/sites-available/adminer.conf <
        ServerName adminer.shopware.local
        DocumentRoot /srv/adminer
        
            Require all granted
        
    
EOF
a2ensite adminer
systemctl restart apache2

```

ps. i also use vagrant plugin hostsupdater to add adminer.shopware.local to hosts file on the host, so you may need to add that manually…

pps. i guess you can also do what someone did in your shopware-5 vm, copy the adminer.php to your shopware directory. (but dunno if .htaccess will rewrite your request to shopware php)

---

<div class="post-metadata">

**Author:** ![flo\_h](https://avatars.discourse-cdn.com/v4/letter/f/439d5e/32.png) [@flo\_h](https://forum.shopware.com/u/flo_h)\
**Post date:** [10. Juli 2019 um 13:05 UTC](https://forum.shopware.com/t/try-to-connect-database-of-shopware-6-but-facing-issue/60347/5 "2019-07-10T13:05:56Z")

</div>

Hi there!

> [@Rizwan schrieb:](https://forum.shopware.com/profile/29119/Rizwan "Rizwan")
> 
> now i am trying to connect database but i what exact url to connect database because there is no link define in vagrant docs

The MySQL database is running on port 3306. You should be able to connect to the database via ‚192.168.33.10:3306‘ by providing your database credentials.

You can install adminer just like wontfix described in his post. The .htaccess only acts for the shopware-dev vhost. If you setup your own adminer apache vhost inside the vagrant box it should work.

&nbsp;

&nbsp;