Untuk <b>MySQL 5.6</b> ke bawah<br /><pre><code class="language-shell">nano /etc/mysql/my.cnf</code></pre>Untuk <b>MySQL 5.7</b> ke atas<br /><pre><code class="language-shell">nano /etc/mysql/mysql.conf.d/mysqld.cnf</code></pre><ul><li>Ganti xxx dengan alamat IP kalian</li></ul><pre><code class="language-shell">bind-address = xxx.xxx.xxx.xxx</code></pre><ul><li>MySQL bisa diakses di semua alamat ip</li></ul><pre><code class="language-shell">#bind-address = xxx.xxx.xxx.xxx </code></pre><div class="separator" style="clear: both; text-align: center;"><a href="https://4.bp.blogspot.com/-e-z-EUS2cuI/WJ10nV6rLsI/AAAAAAAABMs/srtfUY2wOeMAQGehN1yOY0EmqVNtN79HQCLcB/s1600/mysql_hosting.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Remote Connections MySQL Ubuntu" border="0" src="https://4.bp.blogspot.com/-e-z-EUS2cuI/WJ10nV6rLsI/AAAAAAAABMs/srtfUY2wOeMAQGehN1yOY0EmqVNtN79HQCLcB/s1600/mysql_hosting.png" title="Remote Connections MySQL Ubuntu" /></a></div>
Posting Komentar
Posting Komentar