MySQL: Mengijinkan sambungan dari non-localhost - Revision history

Onnowpurbo: /* Edit database mysql di MySQL */

2016-02-15T03:42:42Z

Edit database mysql di MySQL

← Older revision		Revision as of 03:42, 15 February 2016
Line 59:		Line 59:
	\| root \| wiki \|		\| root \| wiki \|
	+------------------+-----------+		+------------------+-----------+

			Update host dari user

			UPDATE mysql.user SET host = {newhost} WHERE user = {youruser};
			UPDATE mysql.user SET host = % WHERE user = root;

Onnowpurbo at 03:36, 15 February 2016

2016-02-15T03:36:16Z

← Older revision		Revision as of 03:36, 15 February 2016
Line 33:		Line 33:

	max_connections = 10000		max_connections = 10000




			==Edit database mysql di MySQL==

			mysql -u root -p123456

			use mysql

			Lihat ijin akses

			select User , Host from user;

			+------------------+-----------+
			\| User \| Host \|
			+------------------+-----------+
			\| mediawiki \| % \|
			\| root \| 127.0.0.1 \|
			\| root \| ::1 \|
			\| debian-sys-maint \| localhost \|
			\| dvwa \| localhost \|
			\| mediawiki \| localhost \|
			\| root \| localhost \|
			\| root \| wiki \|
			+------------------+-----------+

Onnowpurbo at 03:22, 15 February 2016

2016-02-15T03:22:30Z

← Older revision		Revision as of 03:22, 15 February 2016
Line 11:		Line 11:

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

Onnowpurbo at 03:21, 15 February 2016

2016-02-15T03:21:22Z

← Older revision		Revision as of 03:21, 15 February 2016
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

Onnowpurbo at 03:07, 15 February 2016

2016-02-15T03:07:43Z

← Older revision		Revision as of 03:07, 15 February 2016
Line 16:		Line 16:

	Ini sangat berbahaya, karena server mysql kita jadi gampang di hack		Ini sangat berbahaya, karena server mysql kita jadi gampang di hack



			Agar bisa banyak di akses, set

			max_connections = 10000

Onnowpurbo: New page: Agar sambungan dari non-localhost dapat dilakukan, kita perlu mengedit vi /etc/mysql/my.cnf Default bind hanya dari localhost bind-address = 127.0.0.1 Ubah menjadi bind-...

2016-02-15T01:48:49Z

New page: Agar sambungan dari non-localhost dapat dilakukan, kita perlu mengedit vi /etc/mysql/my.cnf Default bind hanya dari localhost bind-address = 127.0.0.1 Ubah menjadi bind-...

New page

Agar sambungan dari non-localhost dapat dilakukan, kita perlu mengedit

vi /etc/mysql/my.cnf

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