unable to access mysql database from python

Question

I tried to access data from mysql database through python then I tried as

import MySQLdb

db = MySQLdb.connect(host = "127.0.0.1",
                     port = 3306,
                      user="Bishnu",
                      password = "Pulchowk",
                      db = "telecom_db")
cursor =db.cursor()
cursor.execute("select * from profile")
numrows = int(cursor.rowcount)
for x in range(numrows):
    row = cursor.fetchone()
    #if (row):
    print row[0], row[1]

cursor.close()

db.cose()

then it shows error

Traceback (most recent call last):
  File "D:\Bishnu\BE\4th year\7th semester\Major Project I\Workspace\Bishnuji\default\first.py", line 43, in <module>
    db = "telecom_db")
  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
TypeError: 'password' is an invalid keyword argument for this function

Then I also tried removing password as

import MySQLdb

db = MySQLdb.connect(host = "127.0.0.1",
                     port = 3306,
                      user="Bishnu",
                      #password = "Pulchowk",
                      db = "telecom_db")
cursor =db.cursor()
cursor.execute("select * from profile")
numrows = int(cursor.rowcount)
for x in range(numrows):
    row = cursor.fetchone()
    #if (row):
    print row[0], row[1]

cursor.close()

db.cose()

still it shows error

Traceback (most recent call last):
  File "D:\Bishnu\BE\4th year\7th semester\Major Project I\Workspace\Bishnuji\default\first.py", line 43, in <module>
    db = "telecom_db")
  File "C:\Python27\lib\site-packages\MySQLdb\__init__.py", line 81, in Connect
    return Connection(*args, **kwargs)
  File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 187, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1044, "Access denied for user ''@'localhost' to database 'telecom_db'")

What may be the solution ?

gipi · Accepted Answer · 2013-04-21 04:36:00Z

11

from the documentation seems that the correct naming of the parameter is passwd

answered Apr 21, 2013 at 4:36

gipi

2,51424 silver badges26 bronze badges

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

2 Comments

Bishnu Bhattarai Over a year ago

I changed my password to passwd still there is the second type error that is _mysql_exceptions.OperationalError: (1044, "Access denied for user ''@'localhost' to database 'telecom_db'")

gipi Over a year ago

Is it normal that the username is missing from the error message? BTW, are you sure that the password is right? are you able to connect from the command line with the same parameters?

Community · Accepted Answer · 2017-05-23 11:48:29Z

2

Check whether you have set password on your database or not. Normally user name and password are not changed and Default user name = 'root' and password filled is null i.e password = ''. If you have set password and forgot it then you can retrieve it by following instruction stated at How do I retrieve my MySQL username and password?

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Apr 23, 2013 at 2:55

nKandel

2,5931 gold badge30 silver badges47 bronze badges

Comments

Hassan ALi · Accepted Answer · 2018-12-27 10:59:35Z

1

Please uninstall and again install the mysqlclient using commands for uninstall

pip uninstall mysqlclient

for install

pip install mysqlclient

edited Dec 27, 2018 at 10:59

Hassan ALi

1,3311 gold badge27 silver badges51 bronze badges

answered Dec 27, 2018 at 7:03

Chetan Kolhe

697 bronze badges

Collectives™ on Stack Overflow

unable to access mysql database from python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related