CODEWITHSUNDEEP
mysqlpython-3.xmysql-connector-python
wish wa
wish wa

Reputation: 23

cursor() and connection() methods are not working while trying to connect MySQL via Python(using Pycharm)

I am trying to connect MySQL database via python. I initially installed mysql-connector which did not work. later I installed mysql-connector-python and connection was successful. But when I tried to use cursor(), getting error:

Code:

import _mysql_connector

mydb = _mysql_connector.MySQL().connect(host="localhost", user="root", password="1234")

mycursor = mydb.cursor()

mycursor.execute("show databases")

Error: AttributeError: 'NoneType' object has no attribute 'cursor'

**

Solved(used alternate module: MySQLdb)

:**

--- mysql.connector did not work for me, I used an alternate module MySQLdb which I installed using pip3 install mysqlclient.

code:

import MySQLdb
mydb = MySQLdb.connect(user="root", host="localhost", password="1234", database="mydatabase")

cursor = mydb.cursor()
cursor.execute("select * from tableName")
for i in cursor:
    print(i)

cursor.close()
mydb.close()

Upvotes: 0

Views: 1339

Answers (1)

N'Bayramberdiyev
N'Bayramberdiyev

Reputation: 3620

You're trying to connect using C Extension Module. Here is basic Connector example:

import mysql.connector

mydb = mysql.connector.connect(user='root', password='1234', host='localhost', database='myDatabase')

cursor = mydb.cursor()

cursor.execute('show databases')

/*
 .
 .
 .
*/

cursor.close()
mydb.close()

Upvotes: 1

Related Questions