> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Integrating MySQL with ClickHouse
> Page describing MySQL integration
export const ExperimentalBadge = () => {
return
;
};
This page covers using the `MySQL` table engine, for reading from a MySQL table.
For ClickHouse Cloud, you can also use the [MySQL ClickPipe](/integrations/clickpipes/mysql/index) (currently in public beta) to easily move data from your MySQL tables to ClickHouse.
Connecting ClickHouse to MySQL using the MySQL Table Engine
The `MySQL` table engine allows you to connect ClickHouse to MySQL. **SELECT** and **INSERT** statements can be made in either ClickHouse or in the MySQL table. This article illustrates the basic methods of how to use the `MySQL` table engine.
1. Configure MySQL
1. Create a database in MySQL:
```sql theme={null}
CREATE DATABASE db1;
```
2. Create a table:
```sql theme={null}
CREATE TABLE db1.table1 (
id INT,
column1 VARCHAR(255)
);
```
3. Insert sample rows:
```sql theme={null}
INSERT INTO db1.table1
(id, column1)
VALUES
(1, 'abc'),
(2, 'def'),
(3, 'ghi');
```
4. Create a user to connect from ClickHouse:
```sql theme={null}
CREATE USER 'mysql_clickhouse'@'%' IDENTIFIED BY 'Password123!';
```
5. Grant privileges as needed. (For demonstration purposes, the `mysql_clickhouse` user is granted admin privileges.)
```sql theme={null}
GRANT ALL PRIVILEGES ON *.* TO 'mysql_clickhouse'@'%';
```
If you're using this feature in ClickHouse Cloud, you may need the to allow the ClickHouse Cloud IP addresses to access your MySQL instance.
Check the ClickHouse [Cloud Endpoints API](/products/cloud/guides/sql-console/query-endpoints) for egress traffic details.
2. Define a Table in ClickHouse
1. Now let's create a ClickHouse table that uses the `MySQL` table engine:
```sql theme={null}
CREATE TABLE mysql_table1 (
id UInt64,
column1 String
)
ENGINE = MySQL('mysql-host.domain.com','db1','table1','mysql_clickhouse','Password123!')
```
The minimum parameters are:
| parameter | Description | example |
| --------- | ---------------------------- | --------------------- |
| host | hostname or IP | mysql-host.domain.com |
| database | mysql database name | db1 |
| table | mysql table name | table1 |
| user | username to connect to mysql | mysql\_clickhouse |
| password | password to connect to mysql | Password123! |
View the [MySQL table engine](/reference/engines/table-engines/integrations/mysql) doc page for a complete list of parameters.
3. Test the Integration
1. In MySQL, insert a sample row:
```sql theme={null}
INSERT INTO db1.table1
(id, column1)
VALUES
(4, 'jkl');
```
2. Notice the existing rows from the MySQL table are in the ClickHouse table, along with the new row you just added:
```sql theme={null}
SELECT
id,
column1
FROM mysql_table1
```
You should see 4 rows:
```response theme={null}
Query id: 6d590083-841e-4e95-8715-ef37d3e95197
┌─id─┬─column1─┐
│ 1 │ abc │
│ 2 │ def │
│ 3 │ ghi │
│ 4 │ jkl │
└────┴─────────┘
4 rows in set. Elapsed: 0.044 sec.
```
3. Let's add a row to the ClickHouse table:
```sql theme={null}
INSERT INTO mysql_table1
(id, column1)
VALUES
(5,'mno')
```
4. Notice the new row appears in MySQL:
```bash theme={null}
mysql> select id,column1 from db1.table1;
```
You should see the new row:
```response theme={null}
+------+---------+
| id | column1 |
+------+---------+
| 1 | abc |
| 2 | def |
| 3 | ghi |
| 4 | jkl |
| 5 | mno |
+------+---------+
5 rows in set (0.01 sec)
```
Summary
The `MySQL` table engine allows you to connect ClickHouse to MySQL to exchange data back and forth. For more details, be sure to check out the documentation page for the [MySQL table engine](/reference/functions/table-functions/mysql).