在终端上用正确的值运行这个命令,我就可以连接并读取数据库:
mysql -h mysql.lyon...fr -u user --password=passworld
我必须在python脚本中执行此操作,我尝试了以下几个函数:
import MySQLdb as mysql
print '======================================================================================'
print 'Connextion to the database'
print '======================================================================================'
# mysql -h mysql.lyon....fr -u XXuser --password=XXpasswd
import MySQLdb as mdb
con = mdb.connect(host='mysql....grid5000.fr' , user='XXuser', passwd='XXpasswdread oar2')
======================================================================================
Connextion to the database
======================================================================================
Traceback (most recent call last):
File "process.py", line 14, in <module>
con = mdb.connect(host='mysql.lyon......fr' , user='user name ', passwd='......')
File "/usr/lib/python2.7/dist-packages/MySQLdb/__init__.py", line 81, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 187, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1045, "Access denied for user 'oarreader'@'flyon.lyon.grid5000.fr' (using password: YES)")
如何在connect函数中定义参数以连接到知道其地址的服务器?你知道吗
您使用的用户与在终端中使用的用户不同,在终端中使用的是-u user,在python中使用的是oarreader
相关问题 更多 >
编程相关推荐