TurnKey Linux Virtual Appliance Library

Access mysql from another ec2 instance

I'm trying to set up a beta server that accesses my production server's database (different files but using same backend data).  Both servers are ec2 instances.  I'm stuck with this error:

 

PDO Connection Error: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 110

Using the symfony turnkey appliance.  Any quick pointers someone can give me to get me started in the right direction? 

Jeremy's picture

Have you configured MySQL to listen?

You'll need to configure MySQL to listen to remote connections (if you haven't already). Instructions are in the wiki. And you'll also need to open the port (in the AWS security profile - not sure how you do that sorry).

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)