Connecting MySQL with PyCharm’s Built‑in Database Tool: Step‑by‑Step Guide

PyCharm provides a built‑in database tool that supports most mainstream databases, including MySQL. This guide walks you through the entire process of connecting to a MySQL instance.

First, open PyCharm and navigate to View → Tool Windows → Database (or click the Database icon on the right side). The database panel will appear.

Click the + button, choose Data Source → MySQL , and fill in the required fields: Name, Comment, Host, Port, User, and Password.

Press Test Connection . If a “Download missing driver files” prompt appears, click Download to install the necessary driver, then test the connection again. A successful test shows a confirmation dialog; click OK .

If the connection succeeds but not all databases are displayed, open the connection settings, go to Schemas , check All Schemas , and confirm.

To run SQL statements, click the console icon in the database panel, type your SQL, and press the run button.

To delete a MySQL connection, select the desired data source in the left pane, then click the - button and confirm the removal.

The article also includes promotional material for a free Python public course, but the core instructional content focuses on using PyCharm for MySQL management.