I can not connect to database

Asked by isdito

Hello:

Python give me this error when I try. What is the problem?

Python File
--------------------------------------------

#!/usr/bin/env python
import mysql.connector

db = mysql.connector.Connect(host="somehost.example.com",user="forovirtualsets",password="******",database="forovirtualsets")
cursor = db.cursor()
cursor.execute("SHOW ENGINES")

cursor.close()
db.close()

----------------------------------------

return -->

----------------------------------------------
Traceback (most recent call last):
  File "test_myconn.py", line 4, in <module>
    db = mysql.connector.Connect(host="somehow.example.com",user="forovirtualsets",password="*******",database="forovirtualsets")
  File "c:\Python25\Lib\site-packages\mysql\connector\__init__.py", line 45, in Connect
    return MySQLConnection(*args, **kwargs)
  File "c:\Python25\Lib\site-packages\mysql\connector\connection.py", line 211, in __init__
    self.connect(*args, **kwargs)
  File "c:\Python25\Lib\site-packages\mysql\connector\connection.py", line 251, in connect
    client_flags=self.client_flags, charset=charset)
  File "c:\Python25\Lib\site-packages\mysql\connector\connection.py", line 281, in _open_connection
    self.protocol.do_handshake()
  File "c:\Python25\Lib\site-packages\mysql\connector\protocol.py", line 337, in do_handshake
    self.conn.open_connection()
  File "c:\Python25\Lib\site-packages\mysql\connector\connection.py", line 169, in open_connection
    values=dict(socketaddr=self.get_address(),errno=m))
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on 'forovirtualsets.db.6357216.hostedresource.com:3306' ((10060, 'Operation timed out'))
>Exit code: 1

Question information

Language:
English Edit question
Status:
Solved
For:
MySQL Connector/Python Edit question
Assignee:
No assignee Edit question
Solved by:
isdito
Solved:
Last query:
Last reply:
Revision history for this message
isdito (virtualsets) said :
#1

I create a database with direct connect and this that works.

Sorry

Revision history for this message
Geert JM Vanderkelen (geertjmvdk) said :
#2

Careful: the trace showed your password (I have removed it). Make sure you change it!