tag:blogger.com,1999:blog-29090812.post1856559532091006506..comments2024-01-23T10:42:13.336+07:00Comments on Newbie Note: Cara Mudah Membuka Akses MySQL Server dari Komputer LainHimawan Mahardiantohttp://www.blogger.com/profile/18034525028250301152noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-29090812.post-66967200468235721972020-07-12T14:30:19.635+07:002020-07-12T14:30:19.635+07:00@asdans versi mysql yang anda gunakan adalah versi...@asdans versi mysql yang anda gunakan adalah versi 5.7 coba saja dibuka file yang ada di /etc/mysql/mysql.conf.d/mysqld.cnf<br /><br />anda akan menemukan baris yang saya maksudHimawan Mahardiantohttps://www.blogger.com/profile/18034525028250301152noreply@blogger.comtag:blogger.com,1999:blog-29090812.post-55149848978030167582020-07-04T22:11:18.262+07:002020-07-04T22:11:18.262+07:00maaf mau tanya, sy cb buka file my.cnf, tapi kenap...maaf mau tanya, sy cb buka file my.cnf, tapi kenapa ya gak ada baris yang dimaksud? <br />adanya spt ini saja..<br /><br /># The MySQL database server configuration file.<br />#<br /># You can copy this to one of:<br /># - "/etc/mysql/my.cnf" to set global options,<br /># - "~/.my.cnf" to set user-specific options.<br /># <br /># One can use all long options that the program supports.<br /># Run program with --help to get a list of available options and with<br /># --print-defaults to see which it would actually understand and use.<br />#<br /># For explanations see<br /># http://dev.mysql.com/doc/mysql/en/server-system-variables.html<br /><br /># This will be passed to all mysql clients<br /># It has been reported that passwords should be enclosed with ticks/quotes<br /># escpecially if they contain "#" chars...<br /># Remember to edit /etc/mysql/debian.cnf when changing the socket location.<br /><br /># Here is entries for some specific programs<br /># The following values assume you have at least 32M ram<br /><br />!includedir /etc/mysql/conf.d/<br />asdanshttp://asdansbacktonature.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-29090812.post-45389662311453845722018-04-19T15:20:02.578+07:002018-04-19T15:20:02.578+07:00Bisa saja, tapi server di kantor harus punya IP pu...Bisa saja, tapi server di kantor harus punya IP publik (bisa di akses via internet), atau client di rumah masuk ke dalam jaringan VPN kantor, bisa pilih salah satu opsi tersebutHimawan Mahardiantohttps://www.blogger.com/profile/18034525028250301152noreply@blogger.comtag:blogger.com,1999:blog-29090812.post-22128616912105315422018-04-19T13:09:41.217+07:002018-04-19T13:09:41.217+07:00Mau tanya gan, kalau komputer server dan client ti...Mau tanya gan, kalau komputer server dan client tidak dalam 1 jaringan, misalnya server di kantor, client di rumah. Bagaimana caranya ya?ibenkhttps://www.blogger.com/profile/02859127176096440020noreply@blogger.comtag:blogger.com,1999:blog-29090812.post-47448759528483326022016-10-30T08:36:18.439+07:002016-10-30T08:36:18.439+07:00Coba bind-address nya di comment saja jadi #bind-a...Coba bind-address nya di comment saja jadi #bind-address, kemudian service mysql di restart, lalu cek pake nmapHimawan Mahardiantohttps://www.blogger.com/profile/18034525028250301152noreply@blogger.comtag:blogger.com,1999:blog-29090812.post-57078250989509810552016-10-29T12:51:05.307+07:002016-10-29T12:51:05.307+07:00gan kalo ip server ada 2(lokal dan publik) saya co...gan kalo ip server ada 2(lokal dan publik) saya coba tambahkan <br />bind-address = ip lokal<br />bind-address = ip publik<br /><br />hasilnya hanya bisa di akses di 1 ip <br /><br />bagaimana caranya agar bisa di akses dari k 2 ip tersebut gan? tolong di bantu y gan.. tq before..<br />Ilham Rhamadanhttps://www.blogger.com/profile/11049076181235236775noreply@blogger.comtag:blogger.com,1999:blog-29090812.post-66667907220932485502016-01-15T10:56:27.355+07:002016-01-15T10:56:27.355+07:00Trmksh infonya gan.. sangat membantu sayaTrmksh infonya gan.. sangat membantu sayasoftware pulsahttp://www.jasaserverpulsa.comnoreply@blogger.com