How to Connect, Query, and Manage MySQL Databases in PyCharm

PyCharm includes a built‑in database tool that supports most mainstream databases; this guide shows how to connect to a MySQL database using that tool.

Open the Database panel by selecting View → Tool Windows → Database or by clicking the Database icon on the right side of the IDE.

Click the + button, choose Data Source → MySQL , and the MySQL connection dialog appears.

Enter the required connection information: • Name – a label for the connection • Comment – a brief description • Host – the MySQL server IP address • Port – the server port • User – the username • Password – the password If the driver is missing, click Download to obtain the required driver files.

After the driver is installed, click Test Connection ; a successful test shows a confirmation dialog—click OK to finish.

To view all databases, open the Schemas tab, check All Schemas , and confirm with OK . All available databases will then be listed.

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

To delete a MySQL data source, select it in the left‑hand list and press the – button.

At the end of the article, a QR code is provided for readers to scan and obtain free Python learning resources.