使用python连接到远程数据库

2024-03-28 08:55:49 发布

您现在位置:Python中文网/ 问答频道 /正文

在终端上用正确的值运行这个命令,我就可以连接并读取数据库:

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函数中定义参数以连接到知道其地址的服务器?你知道吗


Tags: 函数inpyinitconnectlinemysqlpassword