Does ignition login to the database with the root credentials?

General Discussion
1

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.

2

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
image1242×704 26.2 KB

1 Like
3

Will check it out, thanks

4

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

3 Likes