Interface Error While Working with Sql Using Sql Connector

I wanted to run my code which uses sqlconnector, but I can't, my code:

dbconnection.py

import mysql.connector
mydb = mysql.connector.connect(host="localhost", user="yusharthsingh",passwd="xxxxxxxxx")

My Terminal inputs and output:

(ritconda) yusharthsingh@pop-os:~/Documents$ python dbconnection.py
Traceback (most recent call last):
  File "/home/yusharthsingh/anaconda3/envs/ritconda/lib/python3.9/site-packages/mysql/connector/network.py", line 509, in open_connection
    self.sock.connect(sockaddr)
ConnectionRefusedError: [Errno 111] Connection refused

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/yusharthsingh/Documents/dbconnection.py", line 3, in <module>
    mydb = mysql.connector.connect(host="localhost", user="yusharthsingh",passwd="fcukdwrld")
  File "/home/yusharthsingh/anaconda3/envs/ritconda/lib/python3.9/site-packages/mysql/connector/__init__.py", line 179, in connect
    return MySQLConnection(*args, **kwargs)
  File "/home/yusharthsingh/anaconda3/envs/ritconda/lib/python3.9/site-packages/mysql/connector/connection.py", line 95, in __init__
    self.connect(**kwargs)
  File "/home/yusharthsingh/anaconda3/envs/ritconda/lib/python3.9/site-packages/mysql/connector/abstracts.py", line 716, in connect
    self._open_connection()
  File "/home/yusharthsingh/anaconda3/envs/ritconda/lib/python3.9/site-packages/mysql/connector/connection.py", line 206, in _open_connection
    self._socket.open_connection()
  File "/home/yusharthsingh/anaconda3/envs/ritconda/lib/python3.9/site-packages/mysql/connector/network.py", line 511, in open_connection
    raise errors.InterfaceError(
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'localhost:3306' (111 Connection refused)
1

1 Answer

There may be a number of reasons. The most often cited one (see e.g. ) is a small config problem: MySQL does not listen to localhost but to 127.0.0.1. Could your try this?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Maya Lin-Takahashi

Maya Lin-Takahashi

Consumer Tech & Gadget Reviewer

Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.

Share this article
Twitter Facebook Pinterest