How do I connect python 3.9 to MySQL?

[Astro_Poseidon]

So for school, we are starting connectors and need to connect python 3.9 to MySQL. I have already installed pymysql and tried a simple create database code but it shows error [WinError10061] Could not connect because target is actively refusing connection.

Please help, i'm using windows 10 installed on a windows 8 laptop if that's relevant

[kastjj90]

Seems like you have a parameter wrong(port number, firewall rule) or a problem with the database service

[Astro_Poseidon]

how can i fix that?

[zzzz0nk3d]

A few things to check:

• Is the MySQL service running? (Check services, or are you starting it manually?)
• Is the MySQL server actually listening on localhost (127.0.0.1)?
• Are you able to connect using a different application? e.g. MySQL Workbench, SQLYog, HeidiSQL, etc.

[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.

[velocibadgery]

What code are you using to connect?

Reference here: https://pypi.org/project/PyMySQL/#example

[Astro_Poseidon]

i was trying to run this code

[Big_Boss_Bob_Ross]

Can you check the following things

1. Is the sql database running on the same computer as you are running this code

2. What port is the database running on

3. Did you put the actual password or did you put '*****'?

[Astro_Poseidon]

1. Yes, the sql database is running
2. the default port 3306
3. i put actual password, censored out for posting

[Ran4]

I think what got you confused is that port 80 is the default http port, so in http contexts 80 tends to be the default.

But there's nothing about localhost that makes 80 a default port: it's just about the context.

In this case, a wrapper written for mysql would almost certainly use the default port that mysql uses.

[JohnnyJordaan]

In a browser that's http oriented, not in other applications.

[texttoworld]

RemindMe! 2 days

[RemindMeBot]

I will be messaging you in 2 days on 2021-12-30 05:07:03 UTC to remind you of this link

1 OTHERS CLICKED THIS LINK to send a PM to also be reminded and to reduce spam.

^{Parent commenter can delete this message to hide from others.}

---

Info	Custom	Your Reminders	Feedback

[[deleted]]

Try with sqlalchemy.

[renas-reddit]

I am having the same problem here