Tables
Step 1: Set the Database Location
The first thing you need to do to use the Tables feature in FlowMattic is to figure out where your database is located and connect to it if it’s on a different server. Here’s how you can do it step by step.
Is Your Database Local or Remote?
-
Local Database: A local database is the one your current website is already using. Since FlowMattic is installed on this website, it can automatically access the database, so you don’t need to do anything extra. You can jump straight into creating and managing your tables.
-
Remote Database: A remote database is hosted on another server, not on the website where FlowMattic is active. If your database is remote, you’ll need to connect it to FlowMattic first.
How to Connect a Remote Database
If you’re using a remote database, go to FlowMattic’s settings and find the “Connect Database” button. Click it, and you’ll see a form where you’ll need to enter some important information:
-
Label: Give your database a name you can easily recognize later. For example, “Order Management DB.”
-
Description: Write a short note about what this database is used for, like “Stores WooCommerce order details.”
-
Database Name: Type the exact name of your database.
-
Database Host: Enter the server’s address where your database is hosted. This could be an IP address or a domain name.
-
Database User: Provide the username needed to access your database.
-
Database Password: Enter the password for the username you provided.
Testing the Connection
Once you’ve entered all the details, click “Test Connection” to check if everything is set up correctly.
-
If it works: You’ll get a success message, and your database will be ready to use in FlowMattic.
-
If it doesn’t work: You’ll see an error message. Double-check what you entered especially the database name, host, username, and password, and try again.
