The MySQL connector can link your database tables to PostHog.
To link MySQL:
- Go to the Data pipeline page and the sources tab in PostHog
- Click New source and select MySQL
- Enter your database connection details:
- Host: The hostname or IP your database server like
db.example.com
or123.132.1.100
. - Port: The port your database server is listening to. The default is
3306
. - Database: The name of the database you want like
analytics_db
. - User: The username with the necessary permissions to access the database.
- Password: The password for the user.
- Schema: The schema for your database where your tables are located. The default is
public
.
- Host: The hostname or IP your database server like
- Click Link
The data warehouse then starts syncing your MySQL data. You can see details and progress in the sources tab.
Inbound IP addresses
We use a set of IP addresses to access your instance. To ensure this connector works, add these IPs to your inbound security rules to enable the data import:
US | EU |
---|---|
44.205.89.55 | 3.75.65.221 |
44.208.188.173 | 18.197.246.42 |
52.4.194.122 | 3.120.223.253 |