How to Connect and Manage MySQL in PyCharm: Step‑by‑Step Guide

Connect MySQL

Open PyCharm, choose View → Tool Windows → Database or click the Database tool window on the right.

In the Database panel, click the + button → Data Source → MySQL.

Enter the connection details:

Name: connection name

Comment: description

Host: IP address

Port: port number

User: username

Password: password

Test Connection: button to verify the connection

If the dialog shows “Download missing driver files”, click Download to obtain the driver.

After the driver is installed, click Test Connection. A successful message means the database is reachable; click OK.

Show All Schemas

If only a few schemas appear, click the Schemas button, check All Schemas, and confirm with OK.

All databases will now be visible.

Run SQL Statements

Click the console icon in the Database tool window, type your SQL statements, and press the run button.

Delete a MySQL Connection

Select the connection you want to remove in the left pane and click the – button.

Confirm the deletion.