I have attached a screen capture that shows the privileges I have set for my internet facing web app built with Appgini. I am not sure if I have the correct privileges set or not so would love to hear how you set the privileges for your app's MySQL user.
Thanks in advance,
TD
MySQL database user privileges
MySQL database user privileges
- Attachments
-
- mysql db user privileges.jpg (50.54 KiB) Viewed 1677 times
Re: MySQL database user privileges
You should also check 'ALTER'. I'd also recommend 'CREATE TEMPORARY TABLES' .. though this one is not used currently, it might be in future releases.

- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
- Need personalized consulting on your specific app and customizations? Book an online call with me here.