openpolitics.com

url: https://stackoverflow.com/questions/16161889/cant-connect-to-remote-mysql-server-with-error-61

  • Can’t connect to remote MySQL server with error 61

    Modify your configuration:

    <span class="pln">nano </span><span class="pun">/</span><span class="pln">etc</span><span class="pun">/</span><span class="pln">mysql</span><span class="pun">/</span><span class="pln">my</span><span class="pun">.</span><span class="pln">cnf
</span><span class="pun">#</span><span class="pln"> Edit</span><span class="pun">:</span><span class="pln">
bind-address </span><span class="pun">=</span> <span class="lit">0.0.0.0</span>

    Enter mysql and give privileges:

    <span class="pln">mysql </span><span class="pun">-</span><span class="pln">umyuser </span><span class="pun">-</span><span class="pln">pmypassword
</span><span class="pun">#</span><span class="pln"> Run</span><span class="pun">:</span>
<span class="kwd">GRANT</span> <span class="kwd">ALL</span><span class="pln"> PRIVILEGES </span><span class="kwd">ON</span> <span class="pun">*.*</span> <span class="kwd">TO</span> <span class="str">'myuser'</span><span class="pun">@</span><span class="str">'%'</span><span class="pln">IDENTIFIED </span><span class="kwd">BY</span> <span class="str">'mypassword'</span> <span class="kwd">WITH</span> <span class="kwd">GRANT</span> <span class="kwd">OPTION</span><span class="pun">;</span><span class="pln">
FLUSH PRIVILEGES</span><span class="pun">;</span>
<span class="kwd">exit</span>