# Does ignition login to the database with the root credentials?

**URL:** <https://forum.inductiveautomation.com/t/does-ignition-login-to-the-database-with-the-root-credentials/75016>\
**Category:** General Discussion\
**Created:** [June 14, 2023, 1:08pm UTC](https://forum.inductiveautomation.com/t/does-ignition-login-to-the-database-with-the-root-credentials/75016 "2023-06-14T13:08:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\
**Post date:** [June 14, 2023, 1:08pm UTC](https://forum.inductiveautomation.com/t/does-ignition-login-to-the-database-with-the-root-credentials/75016/1 "2023-06-14T13:08:21Z")

</div>

I am using Ignition 8.0.33 and trying to use an existing MYSQL 5.7.

While trying to set this up, The MYSQL keeps asking for the root password.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [June 14, 2023, 1:21pm UTC](https://forum.inductiveautomation.com/t/does-ignition-login-to-the-database-with-the-root-credentials/75016/2 "2023-06-14T13:21:25Z")

</div>

You can connect to MYSQL with root, but you can also create another user on the database side, then use that to make your connection. That way you can limit what the Ignition connection can do in the DB. How Ignition logs in, is set in the connection properties on the gateway webpage.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/f/4f926e4ce2db3f1dcaced21057c3616276bd2e64.png)

---

<div class="post-metadata">

**Author:** ![Brad\_Niemi1](https://avatars.discourse-cdn.com/v4/letter/b/ecd19e/32.png) [@Brad\_Niemi1](https://forum.inductiveautomation.com/u/Brad_Niemi1)\
**Post date:** [June 14, 2023, 7:42pm UTC](https://forum.inductiveautomation.com/t/does-ignition-login-to-the-database-with-the-root-credentials/75016/3 "2023-06-14T19:42:23Z")

</div>

Will check it out, thanks

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 14, 2023, 9:01pm UTC](https://forum.inductiveautomation.com/t/does-ignition-login-to-the-database-with-the-root-credentials/75016/4 "2023-06-14T21:01:08Z")

</div>

> [@dkhayes117](#):
>
> you can also create another user on the database side

And indeed, you should. As a general principle, always provide as little access as possible.