MySQL
Read-only session and a time limit on every query.
- How it connects
- Lindero opens the session and transactions read-only, with a time limit on every query. In MySQL the catalogue is information_schema, and a test checks that a SELECT-only account sees its keys and relationships.
- What it reads
- Tables, views, keys, relationships and procedures. When rows need counting, the database counts them itself and returns only the number.
- Which account it needs
- A MySQL user with SELECT permission. If you want it to read stored procedures, EXECUTE as well: without it, MySQL hides them and none appear, with no error.
- Can it write?
- No. Lindero never writes to a program's database.
More Databases connectors
All connectors
Shall we connect it in your company?
We tell you what your case needs and leave it running on your server.