python 无法加载mysql数据库_无法从python访问mysql数据库

我试图通过

python从mysql数据库访问数据,然后我尝试了

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()

然后它显示错误

Traceback (most recent call last):

File "D:BishnuBE4th year7th semesterMajor Project IWorkspaceBishnujidefaultfirst.py", line 43, in

db = "telecom_db")

File "C:Python27libsite-packagesMySQLdb__init__.py", line 81, in Connect

return Connection(*args, **kwargs)

File "C:Python27libsite-packagesMySQLdbconnections.py", line 187, in __init__

super(Connection, self).__init__(*args, **kwargs2)

TypeError: 'password' is an invalid keyword argument for this function

然后我也尝试删除密码为

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()

仍然显示错误

Traceback (most recent call last):

File "D:BishnuBE4th year7th semesterMajor Project IWorkspaceBishnujidefaultfirst.py", line 43, in

db = "telecom_db")

File "C:Python27libsite-packagesMySQLdb__init__.py", line 81, in Connect

return Connection(*args, **kwargs)

File "C:Python27libsite-packagesMySQLdbconnections.py", line 187, in __init__

super(Connection, self).__init__(*args, **kwargs2)

_mysql_exceptions.OperationalError: (1044, "Access denied for user ''@'localhost' to database 'telecom_db'")

可能是什么解决方案？