Python - MySQL connection error

Question

I use Python 3.5.2 and PyMySQL

and after creating the database of MySQL

import pymysql

conn = pymysql(host='127.0.0.1',unix_socket='/tmp/mysql.sock',user='root',passwd=None,db='mysql')

AttributeError: module 'socket' has no attribute 'AF_UNIX'

p.s. when setting MySQL in my win10,the port 3306 can't work(make me unable to continue)

so I change the port to 306 and then work

Has that any impact on my error?

it shows some error...

Why do you connect through the socket, not through the port? — DYZ
– DYZ, Commented Dec 4, 2016 at 0:35

Community · Accepted Answer · 2021-06-23 02:38:55Z

1

If you are running on Windows, you cannot use a Unix socket to connect to the database. When connecting, set the host and port parameters instead of unix_socket.

conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='Your password', db='mysql')

edited Jun 23, 2021 at 2:38

CommunityBot

11 silver badge

answered Dec 4, 2016 at 1:53

Kevin Schellenberg

8456 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python - MySQL connection error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related