MySQL: Mengijinkan sambungan dari non-localhost: Difference between revisions

Revision as of 03:22, 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
skip-networking

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

Revision as of 03:21, 15 February 2016 view source Onnowpurbo (talk \| contribs) 69,477 edits No edit summary ← Older edit		Revision as of 03:22, 15 February 2016 view source Onnowpurbo (talk \| contribs) 69,477 edits No edit summary Newer edit →
Line 11:		Line 11:

	skip-name-resolve		skip-name-resolve
			skip-networking