MySQL CSV Automation & Roles -- 2

Замовник: AI | Опубліковано: 24.12.2025

I need a clean MySQL setup that automatically ingests two separate CSV files every day and keeps them ready for use moments after they arrive. Alongside that, three database users—Admin, Editor, and Viewer—must be created with clearly separated privileges: full control for Admin, write-plus-read for Editor, and read-only for Viewer. Once the data is flowing in, I will rely on a set of reusable SQL scripts to: • pull records that match specific conditions (think filtered reports for my dashboards) • perform controlled data updates or inserts triggered from my application layer Deliverables will be considered complete when: • both CSVs import on schedule without manual intervention • the three user accounts enforce the required privilege boundaries • all retrieval and manipulation queries run error-free on real sample data • straightforward documentation shows how to rerun, modify, or extend the process in the future Feel free to suggest whether cron, LOAD DATA INFILE, or another method best suits the daily import—robustness is the priority.