MySQLdb 连接Mysql 数据库出错解决

 

1. #coding=utf-8
2. importMySQLdb
3. if__name__=="__main__":
4. db=MySQLdb.connect(host=<spanstyle="color:#FF0000;">'localhost'</span>,
5. port=3306,
6. user='root',
7. passwd=XX',
8. db='XX')
9. cursor=db.cursor()
10. sql="select*fromstudent"
11. cursor.execute(sql)
12. forlineincursor.fetchall():
13. printline
14. db.close()

运行时出现如下错误：

 

[plain] view plain copy

 

1. pydevdebugger:starting
2. Traceback(mostrecentcalllast):
3. File"C:\ProgramFiles\aptan3\plugins\org.python.pydev_2.6.0.2012062121\pysrc\pydevd.py",line1392,in<module>
4. debugger.run(setup['file'],None,None)
5. File"C:\ProgramFiles\aptan3\plugins\org.python.pydev_2.6.0.2012062121\pysrc\pydevd.py",line1085,inrun
6. pydev_imports.execfile(file,globals,locals)#executethescript
7. File"D:\AptanaStudio3Workspace\first\com\lin\test01.py",line9,in<module>
8. db='netbase')
9. File"E:\python27\lib\site-packages\MySQLdb\__init__.py",line81,inConnect
10. returnConnection(*args,**kwargs)
11. File"E:\python27\lib\site-packages\MySQLdb\connections.py",line187,in__init__
12. super(Connection,self).__init__(*args,**kwargs2)
13. _mysql_exceptions.OperationalError:(2003,"Can'tconnecttoMySQLserveron'localhost'(10061)")

把host="localhost" 改为 host="127.0.0.1"就可以了

 

 

[python] view plain copy

 

1. #coding=utf-8
2. importMySQLdb
3. if__name__=="__main__":
4. db=MySQLdb.connect(<spanstyle="color:#FF0000;">host='127.0.0.1',</span>
5. port=3306,
6. user='root',
7. passwd=XX',
8. db='XX')
9. cursor=db.cursor()
10. sql="select*fromstudent"
11. cursor.execute(sql)
12. forlineincursor.fetchall():
13. printline
14. db.close()

运行如下：

 

 

[plain] view plain copy

 

1. pydevdebugger:starting
2. ('lin',88L)
3. ('cjm',8L)

Django + MySQLdb + Mysql settings 文件数据库设置：

 

 

[plain] view plain copy

 

1. DATABASES={
2. 'default':{
3. 'ENGINE':'django.db.backends.mysql',#Add'postgresql_psycopg2','mysql','sqlite3'or'oracle'.
4. 'NAME':'mydb',#Orpathtodatabasefileifusingsqlite3.
5. #Thefollowingsettingsarenotusedwithsqlite3:
6. 'USER':'root',
7. 'PASSWORD':'mydb',
8. #'HOST':'',
9. 'HOST':'127.0.0.1',#Emptyforlocalhostthroughdomainsocketsor'127.0.0.1'forlocalhostthroughTCP.
10. 'PORT':'3306',#Settoemptystringfordefault.
11. }
12. }

然后连接数据库：

[plain] view plain copy

 

1. importsys;print('%s%s'%(sys.executableorsys.platform,sys.version))
2. PyDevconsole:usingdefaultbackend(IPythonnotavailable).
3. E:\python27\python.exe2.7.5(default,May152013,22:43:36)[MSCv.150032bit(Intel)]
4. fromdjango.coreimportmanagement;importnetbase.settingsassettings;management.setup_environ(settings)
5. u'D:\\AptanaStudio3Workspace\\netbase\\netbase'
6. fromdjango.dbimportmodels
7. fromdjango.dbimportconnection
8. cursor=connection.cursor()

转：http://blog.csdn.net/jinnian_lin/article/details/10071081

1. #coding=utf-8
2. importMySQLdb
3. if__name__=="__main__":
4. db=MySQLdb.connect(host=<spanstyle="color:#FF0000;">'localhost'</span>,
5. port=3306,
6. user='root',
7. passwd=XX',
8. db='XX')
9. cursor=db.cursor()
10. sql="select*fromstudent"
11. cursor.execute(sql)
12. forlineincursor.fetchall():
13. printline
14. db.close()

运行时出现如下错误：

 

[plain] view plain copy

 

1. pydevdebugger:starting
2. Traceback(mostrecentcalllast):
3. File"C:\ProgramFiles\aptan3\plugins\org.python.pydev_2.6.0.2012062121\pysrc\pydevd.py",line1392,in<module>
4. debugger.run(setup['file'],None,None)
5. File"C:\ProgramFiles\aptan3\plugins\org.python.pydev_2.6.0.2012062121\pysrc\pydevd.py",line1085,inrun
6. pydev_imports.execfile(file,globals,locals)#executethescript
7. File"D:\AptanaStudio3Workspace\first\com\lin\test01.py",line9,in<module>
8. db='netbase')
9. File"E:\python27\lib\site-packages\MySQLdb\__init__.py",line81,inConnect
10. returnConnection(*args,**kwargs)
11. File"E:\python27\lib\site-packages\MySQLdb\connections.py",line187,in__init__
12. super(Connection,self).__init__(*args,**kwargs2)
13. _mysql_exceptions.OperationalError:(2003,"Can'tconnecttoMySQLserveron'localhost'(10061)")

把host="localhost" 改为 host="127.0.0.1"就可以了

 

 

[python] view plain copy

 

1. #coding=utf-8
2. importMySQLdb
3. if__name__=="__main__":
4. db=MySQLdb.connect(<spanstyle="color:#FF0000;">host='127.0.0.1',</span>
5. port=3306,
6. user='root',
7. passwd=XX',
8. db='XX')
9. cursor=db.cursor()
10. sql="select*fromstudent"
11. cursor.execute(sql)
12. forlineincursor.fetchall():
13. printline
14. db.close()

运行如下：

 

 

[plain] view plain copy

 

1. pydevdebugger:starting
2. ('lin',88L)
3. ('cjm',8L)

Django + MySQLdb + Mysql settings 文件数据库设置：

 

 

[plain] view plain copy

 

1. DATABASES={
2. 'default':{
3. 'ENGINE':'django.db.backends.mysql',#Add'postgresql_psycopg2','mysql','sqlite3'or'oracle'.
4. 'NAME':'mydb',#Orpathtodatabasefileifusingsqlite3.
5. #Thefollowingsettingsarenotusedwithsqlite3:
6. 'USER':'root',
7. 'PASSWORD':'mydb',
8. #'HOST':'',
9. 'HOST':'127.0.0.1',#Emptyforlocalhostthroughdomainsocketsor'127.0.0.1'forlocalhostthroughTCP.
10. 'PORT':'3306',#Settoemptystringfordefault.
11. }
12. }

然后连接数据库：

[plain] view plain copy

 

1. importsys;print('%s%s'%(sys.executableorsys.platform,sys.version))
2. PyDevconsole:usingdefaultbackend(IPythonnotavailable).
3. E:\python27\python.exe2.7.5(default,May152013,22:43:36)[MSCv.150032bit(Intel)]
4. fromdjango.coreimportmanagement;importnetbase.settingsassettings;management.setup_environ(settings)
5. u'D:\\AptanaStudio3Workspace\\netbase\\netbase'
6. fromdjango.dbimportmodels
7. fromdjango.dbimportconnection
8. cursor=connection.cursor()

转：http://blog.csdn.net/jinnian_lin/article/details/10071081