Knowledge base
1000 FAQs, 500 tutorials and explanatory videos. Here, there are only solutions!
Managing temporary database tables
This guide explains how to allow access to MySQL/MariaDB temporary tables from Infomaniak Web hosting. Using temporary tables in a database allows:
- temporarily store data for specific processing or operations; e.g., when a stored procedure or function needs to manipulate a temporary dataset without altering the permanent data in the database
- store intermediate data to optimize query performance; data manipulations can be faster on a temporary table than on a permanent table, especially if the temporary table is well indexed and tailored to the current task
- isolate temporary data used by different sessions or users; this avoids potential conflicts when multiple users simultaneously access the same temporary table
- manage transactions, where operations need to be performed atomically; they can be used to store intermediate data during the course of a transaction, and then be removed once the transaction is completed
- simplify the process when complex operations need to be performed on data, by allowing operations to be broken down into more manageable steps
Creating a Database User
For this:
- log in to the Infomaniak Manager (manager.infomaniak.com) from a web browser such as Brave or Edge
- click on the icon at the top right of the interface (or navigate through the left side menu, for example)
- select Hosting (universe Web & Domain)
- click on the name of the relevant object in the displayed table
- click on Databases in the left side menu
- from the User tab, click Add to create a new user
Allow Access to Temporary Tables
For this:
- still from the User tab, make sure that the user:
- has rights in: read + write + admin
- or has rights in: read + write
- adjust the user's rights as needed and click Validate
Link to this FAQ: