Difference between revisions of "MySQL: Mengijinkan sambungan dari non-localhost"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
| Line 2: | Line 2: | ||
vi /etc/mysql/my.cnf | vi /etc/mysql/my.cnf | ||
| + | |||
| + | |||
| + | Di bagian | ||
| + | |||
| + | [mysqld] | ||
| + | |||
| + | Tambahkan | ||
| + | |||
| + | skip-name-resolve | ||
| + | |||
| + | |||
Default bind hanya dari localhost | Default bind hanya dari localhost | ||
Revision as of 10:21, 15 February 2016
Agar sambungan dari non-localhost dapat dilakukan, kita perlu mengedit
vi /etc/mysql/my.cnf
Di bagian
[mysqld]
Tambahkan
skip-name-resolve
Default bind hanya dari localhost
bind-address = 127.0.0.1
Ubah menjadi
bind-address = ip.address.anda
Atau kalau mau mengijinkan sambungan dari semua IP address, ubah menjadi
bind-address = 0.0.0.0
Ini sangat berbahaya, karena server mysql kita jadi gampang di hack
Agar bisa banyak di akses, set
max_connections = 10000