From The Document Foundation Wiki
Is it possible to connect Calc to a MySQL database installed at my hosting service? If so, what parameters are required in the database management control?
It is possible if two conditions are fulfilled :
- MySQL ODBC is installed on the client
- The host allows remote access to the database
If these are in place, simply enter a description of the database in the ODBC manager and connect!