Having this error can anyone help

Smitha Jain

4y877Python

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Uday Dodiya4y ago
Accepted answer
pass the port as different argiment, don't pass with host, like following
conn = msql.connect(host='localhost', port=3306, user='root', password='root123')
+1
Smitha Jain4y ago
thanks guys
+1
Amit Mohanty4y ago
This error occurs because you are combining the hostname and port in in the call to Connect. pass the port as an integer, using the port keyword argument.
conn = msql.connect(host='localhost', port=3306, user='root', password='root123')
+2

Rajanikant Hawaldar4y ago

Refer below article

https://www.c-sharpcorner.com/blogs/crud-operations-in-python-using-mysql-database

Below sample code works

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='Electronics',
                                         user='pynative',
                                         password='pynative@#29', use_pure=True)

    if connection.is_connected():
        db_Info = connection.get_server_info()
        print("Connected to MySQL database... MySQL Server version on ", db_Info)
except Error as e:
    print("Error while connecting to MySQL", e)
finally:
    if connection.is_connected():
        connection.close()
        print("MySQL connection is closed")