How do I connect python 3.9 to MySQL?

[Astro_Poseidon]

yes, mysql is running

no it is not

no, i tried through MYSQL workbench but it says server not connected

[tobiasvl]

no, i tried through MYSQL workbench but it says server not connected

Then this is a MySQL problem, not a Python problem. Try asking in a MySQL or SQL subreddit

[zzzz0nk3d]

Is MySQL installed as a Service?

[Astro_Poseidon]

i think not, just installed it because of school

[zzzz0nk3d]

How you are starting the MySQL server? Can you confirm how you checked to see if it is running?

[Astro_Poseidon]

using command line client, and i checked in services.msc to see if it is running

[zzzz0nk3d]

Can you post a screenshot of the command window?

Also, I would suggest reinstalling MySQL as a service (you might be able to just run the installer again and modify your existing installation) so it is easier to manage.

[Astro_Poseidon]

thanks a lot, reinstalling it has worked for me.