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>