What are the minimum permissions that should be given to a remote MYSQL database to allow Ignition to work? I do not want to give more then is needed.
These include:
Select
Insert
Update
Delete
Create
Drop
Grant
…ETC there are many more.
This is a hard question to answer, because none of these are needed to “allow Ignition to work”, since strictly speaking Ignition doesn’t require a connection to a database.
Now, many of Ignition’s features obviously do require a connection. But what permissions you’ll need depends on what you’re trying to do. If all you need to do is read data, then the SELECT permission is all you’ll need. If you want to user more features like the SQLBridge module and/or an external SQLTags provider you’ll need the ability to do all the CRUD operations (SELECT, INSERT, UPDATE, DELETE, and potentially EXECUTE), as well as table creation (CREATE, ALTER, INDEX)
Hope this helps,
Thanks Carl.
Jim