TurnKey Linux Virtual Appliance Library

Connecting to mysql from another host

john_4's picture

I want to set up my turnkey lamp appliance so that I can connect to mysql from another host using tools like mysql administrator, phprunner, etc. I have set up a user account for this, and set the 'hosts' to '%', but connection is still refused. I recall that allowing connections from other hosts is disabled as standard as a security precaution, but that doesn't worry me (this is a virtual test server on a private lan). Does anyone know how to enable access from another host?

Jeremy Davis's picture

Have a look in the docs

Have a look here. That was written to apply to the current stable releases (v2009.10-2) but I would think that it'd apply to the v11.0RC too. Let us know how you go, particularly if you're using the RC. It'd be good to confirm the instructions apply to that too.

Rachel Y's picture

Thanks you for the reply.

Thanks you for the reply.

Guest's picture

I am looking for the same

I am looking for the same thing./..i want to do it for my clients wordpress blog..I am not so good in coding..so any plugin or tool that can help me.  seencuentra.com is  blog..

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)