OK needed to allow port 3306 for mysql. Grant accesses on the database.
Thanks,
Gary C
--- On Thu, 6/16/11, gary clark <burslem2...@yahoo.com> wrote:
> From: gary clark <burslem2...@yahoo.com>
> Subject: [Twisted-Python] Failure to connect remotely to MySQL database
> To: "Twisted general discussion" <twisted-python@twistedmatrix.com>
> Date: Thursday, June 16, 2011, 5:46 PM
> Hello,
>
> I am trying to connect a twisted server to a remote machine
> which contains the mysql database, unfortunately I cannot
> access the database am am seeing error:
>
> Failed to load application: Cant connect to MySQL on server
> 192.168.1.10.
>
> db=create_engine('mysql://root:pwd@192.168.1.10/database',echo=True)
>
> The databse machine has a number of restrictions on the
> firewall. I can ping the database machine and can see the
> that mysqld is running and enabled. What need to be open and
> enabled to access the mysql server from another machine i.e
> what port and connection type.
>
> I dont see anything in the mysqld log.
>
> Cheers,
> Gary C
>
>
> _______________________________________________
> Twisted-Python mailing list
> Twisted-Python@twistedmatrix.com
> http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
>
_______________________________________________
Twisted-Python mailing list
Twisted-Python@twistedmatrix.com
http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
