connect to remote database via python script

[sunstar20]

Hi,

I am able to connect to local database via python script.
For ex: MySQLdb.connect("localhost","testuser","test123","test" )

I want to connect to remote database via python script.

Could you please help.

[Gribouillis]

You can probably replace the "localhost" by the host's IP address such as "127.0.0.1"

[sunstar20]

Getting the below error:

# python test.py

Error:
Traceback (most recent call last):
  File "test.py", line 6, in <module>
    db = MySQLdb.connect("1.2.3.4","testuser","test123","test" )
  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 204, in __init__
    super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (2003, "Can't connect to MySQL server on '1.2.3.4' (110)")

Are there any other settings required for binding the remote ip of the remote database

[Gribouillis]

Is your server's IP address '1.2.3.4' ? Try to connect to the mysql server out of python (such as with the mysql command in a terminal).

[sunstar20]

current system ip for example: x.y.z.k

I am trying to connect to the remote database of the remote server i.e 1.2.3.4

connecting to 1.2.3.4 from x.y.z.k

Error:
# mysql --host=1.2.3.4 --user=testuser --password=test123 TEST
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on '1.2.3.4' (111)

[Gribouillis]

Did you check the troubleshooting page?