I am trying basic MySQL connection as follows:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost", port = "3306",
user="sample",
password=" "
)
print(mydb)
and occurs with following error:
Traceback (most recent call last):
File "C:UsersparrotAppDataLocalProgramsPythonPython312Libsite-packagesmysqlconnectorconnection_cext.py", line 334, in _open_connection
self._cmysql.connect(**cnx_kwargs)
_mysql_connector.MySQLInterfaceError: Can't connect to MySQL server on 'localhost:3306' (10061)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "E:sample_prgcheck_sql.py", line 3, in <module>
mydb = mysql.connector.connect(
File "C:UsersparrotAppDataLocalProgramsPythonPython312Libsite-packagesmysqlconnectorpooling.py", line 322, in connect
return CMySQLConnection(*args, **kwargs)
File "C:UsersparrotAppDataLocalProgramsPythonPython312Libsite-packagesmysqlconnectorconnection_cext.py", line 151, in __init__
self.connect(**kwargs)
File "C:UsersparrotAppDataLocalProgramsPythonPython312Libsite-packagesmysqlconnectorabstracts.py", line 1399, in connect
self._open_connection()
File "C:UsersparrotAppDataLocalProgramsPythonPython312Libsite-packagesmysqlconnectorconnection_cext.py", line 339, in _open_connection
raise get_mysql_exception(
mysql.connector.errors.DatabaseError: 2003 (HY000): Can't connect to MySQL server on 'localhost:3306' (10061)
I am working on Windows 11