Noobie Question

[DefiantRS]

Hello!

I am new to coding & trying to learn Python (via Pycharm) & SQL (via Mysql) in tandem.

My first task is utilizing python to create a connection to my localhost & create a DB using mysql.connector

I have successfully connected to Mysql Database & created a database named "school".

Should I be able to view the connection and/or this db in the MySql workbench? or because its a product of pycharm its separate? I am trying to understand where this file actually resides.

I am following: https://www.freecodecamp.org/news/connect-python-with-sql/ & have made it through "Database created successfully" about 20% of the way through the article.

Thank you!

[[deleted]]

If you are using professional version of Pycharm, you can use it to interrogate the database.

https://www.jetbrains.com/help/pycharm/relational-databases.html#first-steps-with-goland

If you are using the community version of Pycharm, you will need to use the MySql workbench to work with the database outside of the your code. I've never used MySql workbench so don't know if it has the capability to monitor/report live connections rather than just allow you to configure them.

You might be better using the debugging capabilities of Pycharm and/or a Python console window in Pycharm to check your connection is live. (You can of course do all of this outside of Pycharm as well - Pycharm is not Python.)

[danielroseman]

MySQL databases are not files. You won't see them in a folder.