Accessing MySQL through Python

Dan0031 · 8-5-12, 10:11 PM

Has anyone successfully connected to their MySQL database via Python? Using the control panel there is a button that generates the code, but when I run it in Python I get the error:

Unknown MySQL server host 'cinemit.powwebmysql.com' (11004)

This should be a simple matter of correcting the host address, but the help over chat was laughably unhelpful. I'm confident I have the required Python modules correctly installed, and that I am connecting to the default port. Any thoughts?

Thanks!

shrupa · 8-6-12, 03:36 AM

it seems its an issue with dns for ur mysql host. check weter it works wit php?

Dan0031 · 8-6-12, 10:52 AM

Shrupa, thanks for your response. I agree, it probably is a problem with the host address, but I don't know what else to use. Do you have any suggestions for a different host address to use, or where to check? The PHP code that is generated has the same host address so I doubt it would make any difference.

entrecon · 8-6-12, 11:50 AM

Is the Python code running on PowWeb? One thing to note, unless things have changed, PowWeb does not allow access to the MySQL from a resource outside of PowWeb. I know in the past individuals have had trouble with this when trying to do the development on their local machine while trying to pull the data from the server.

shrupa · 8-6-12, 04:12 PM

contact support to correct mysql host.

8-5-12, 10:11 PM	#1
Dan0031 Registered Join Date: Aug 2012 Location: New York City Posts: 2 Reputation: 0	Accessing MySQL through Python Has anyone successfully connected to their MySQL database via Python? Using the control panel there is a button that generates the code, but when I run it in Python I get the error: Unknown MySQL server host 'cinemit.powwebmysql.com' (11004) This should be a simple matter of correcting the host address, but the help over chat was laughably unhelpful. I'm confident I have the required Python modules correctly installed, and that I am connecting to the default port. Any thoughts? Thanks!

8-6-12, 03:36 AM	#2
shrupa Join Date: Feb 2009 Location: India Posts: 165 Reputation: 32	it seems its an issue with dns for ur mysql host. check weter it works wit php? __________________

8-6-12, 11:50 AM	#4
entrecon Custom User Title Join Date: Aug 2006 Location: Michigan Posts: 2,669 Reputation: 337	Is the Python code running on PowWeb? One thing to note, unless things have changed, PowWeb does not allow access to the MySQL from a resource outside of PowWeb. I know in the past individuals have had trouble with this when trying to do the development on their local machine while trying to pull the data from the server. __________________ ________________________________ Find me on twitter: @entrecon

8-6-12, 04:12 PM	#5
shrupa Join Date: Feb 2009 Location: India Posts: 165 Reputation: 32	contact support to correct mysql host. __________________

8-6-12, 10:52 AM	#3
Dan0031 Registered Join Date: Aug 2012 Location: New York City Posts: 2 Reputation: 0	Shrupa, thanks for your response. I agree, it probably is a problem with the host address, but I don't know what else to use. Do you have any suggestions for a different host address to use, or where to check? The PHP code that is generated has the same host address so I doubt it would make any difference.