MySQL Workbench - Revision history

Kangtain: Kangtain moved page Software/MySQL Workbench to MySQL Workbench over redirect

2022-11-19T14:22:31Z

Kangtain moved page Software/MySQL Workbench to MySQL Workbench over redirect

← Older revision	Revision as of 21:22, 19 November 2022
(No difference)

Kangtain: /* Source */

2022-11-18T23:12:43Z

Source

← Older revision		Revision as of 06:12, 19 November 2022
Line 48:		Line 48:
	[[Category:SQL]]		[[Category:SQL]]
	[[Category:Database]]		[[Category:Database]]
	~~{{DISPLAYTITLE:MySQL Workbench}}~~

Kangtain at 11:33, 5 November 2022

2022-11-05T11:33:56Z

← Older revision		Revision as of 18:33, 5 November 2022
Line 1:		Line 1:
	'''MySQL Workbench''' adalah sebuah perangkat aplikasi berbentuk visual yang dipergunakan untuk mengelola basis data. Perangkat aplikasi ini biasa digunakan oleh seorang arsitek basis data, pengembang basis data, serta administator basis data. MySQL Workbench menyediakan model data, pengembangan SQL, dan peralatan administrasi yang komperhensif untuk konfigurasi server basis data, administrasi pengguna, dan masih banyak lagi. MySQL Workbench tersedia pada platform Windows, Linux dan Mac OS		'''MySQL Workbench''' adalah sebuah perangkat [[Software\|aplikasi]] berbentuk visual yang dipergunakan untuk mengelola basis data. Perangkat [[Software\|aplikasi]] ini biasa digunakan oleh seorang arsitek basis data, pengembang basis data, serta administator basis data. [[MySQL]] Workbench menyediakan model data, pengembangan [[SQL]], dan peralatan administrasi yang komperhensif untuk konfigurasi server basis data, administrasi pengguna, dan masih banyak lagi. [[MySQL]] Workbench tersedia pada platform [[Windows]], [[Linux]] dan [[MacOS\|Mac OS]]

	===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===		== Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements ==
	Create a database user with a weak password:		Create a database user with a weak password:

Kangtain at 11:31, 5 November 2022

2022-11-05T11:31:44Z

← Older revision		Revision as of 18:31, 5 November 2022
Line 1:		Line 1:
			'''MySQL Workbench''' adalah sebuah perangkat aplikasi berbentuk visual yang dipergunakan untuk mengelola basis data. Perangkat aplikasi ini biasa digunakan oleh seorang arsitek basis data, pengembang basis data, serta administator basis data. MySQL Workbench menyediakan model data, pengembangan SQL, dan peralatan administrasi yang komperhensif untuk konfigurasi server basis data, administrasi pengguna, dan masih banyak lagi. MySQL Workbench tersedia pada platform Windows, Linux dan Mac OS

	===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===		===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===
	Create a database user with a weak password:		Create a database user with a weak password:

Kangtain at 23:16, 26 October 2022

2022-10-26T23:16:22Z

← Older revision		Revision as of 06:16, 27 October 2022
Line 1:		Line 1:
	===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===		===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===
	Create a database user with a weak password:<syntaxhighlight lang="shell">		Create a database user with a weak password:

			<syntaxhighlight lang="shell">
	sudo mysql -u root		sudo mysql -u root
	</syntaxhighlight><syntaxhighlight lang="shell">		</syntaxhighlight>

			<syntaxhighlight lang="shell">
	create user 'ostechnix'@'localhost' identified by 'mypassword';		create user 'ostechnix'@'localhost' identified by 'mypassword';
	</syntaxhighlight>Terdapat error seperti berikut<syntaxhighlight lang="shell">		</syntaxhighlight>

			Terdapat error seperti berikut

			<syntaxhighlight lang="shell">
	ERROR 1819 (HY000): Your password does not satisfy the current policy requirements		ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
	</syntaxhighlight>Pada saat menjalankan <syntaxhighlight lang="shell">		</syntaxhighlight>

			Pada saat menjalankan

			<syntaxhighlight lang="shell">
	sudo mysql_secure_installation utility		sudo mysql_secure_installation utility
	</syntaxhighlight>Memilih salah satu		</syntaxhighlight>

			Memilih salah satu
	*<code>LOW</code> Length >= 8 characters.		*<code>LOW</code> Length >= 8 characters.
	*<code>MEDIUM</code> Length >= 8, numeric, mixed case, and special characters.		*<code>MEDIUM</code> Length >= 8, numeric, mixed case, and special characters.
	*<code>STRONG</code> Length >= 8, numeric, mixed case, special characters and dictionary file.		*<code>STRONG</code> Length >= 8, numeric, mixed case, special characters and dictionary file.
			*Jika memilih MEDIUM buatlah password yang mengandung huruf aphabet kapital dan kecil lalu berikan tanda baca serta angka. Berikut adalah contoh perintahnya

	*Jika memilih MEDIUM buatlah password yang mengandung huruf aphabet kapital dan kecil lalu berikan tanda baca serta angka. Berikut adalah contoh perintahnya
	<syntaxhighlight lang="shell">		<syntaxhighlight lang="shell">
	ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Qweewq*#123';		ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Qweewq*#123';
	</syntaxhighlight>		</syntaxhighlight>

	*Perintah berikut digunakan untuk mengubah password pada user root		*Perintah berikut digunakan untuk mengubah password pada user root
	*Jika ingin membuat user baru, berikut adalah perintahnya		*Jika ingin membuat user baru, berikut adalah perintahnya

	<syntaxhighlight lang="shell">		<syntaxhighlight lang="shell">
	create user 'ostechnix'@'localhost' identified by 'Qweewq*#123';		create user 'ostechnix'@'localhost' identified by 'Qweewq*#123';
Line 27:		Line 43:
	*[https://dev.to/gsudarshan/how-to-install-mysql-and-workbench-on-ubuntu-20-04-localhost-5828 dev.to]		*[https://dev.to/gsudarshan/how-to-install-mysql-and-workbench-on-ubuntu-20-04-localhost-5828 dev.to]
	*[https://stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges stackoverflow.com]		*[https://stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges stackoverflow.com]

	[[Category:SQL]]		[[Category:SQL]]
	[[Category:Database]]		[[Category:Database]]
	{{DISPLAYTITLE:MySQL Workbench}}		{{DISPLAYTITLE:MySQL Workbench}}

Kangtain: /* Source */

2022-09-09T10:49:12Z

Source

← Older revision		Revision as of 17:49, 9 September 2022
Line 29:		Line 29:
	[[Category:SQL]]		[[Category:SQL]]
	[[Category:Database]]		[[Category:Database]]
			{{DISPLAYTITLE:MySQL Workbench}}

Kangtain: Kangtain moved page MySQL Workbench to Software/MySQL Workbench

2022-09-09T10:48:49Z

Kangtain moved page MySQL Workbench to Software/MySQL Workbench

← Older revision	Revision as of 17:48, 9 September 2022
(No difference)

Kangtain at 12:39, 25 August 2022

2022-08-25T12:39:54Z

← Older revision		Revision as of 19:39, 25 August 2022
Line 1:		Line 1:
	===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===		===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===
	Create a database user with a weak password:		Create a database user with a weak password:<syntaxhighlight lang="shell">
	sudo mysql -u root		sudo mysql -u root
			</syntaxhighlight><syntaxhighlight lang="shell">
	create user 'ostechnix'@'localhost' identified by 'mypassword';		create user 'ostechnix'@'localhost' identified by 'mypassword';
			</syntaxhighlight>Terdapat error seperti berikut<syntaxhighlight lang="shell">
	Terdapat error seperti berikut		ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
	ERROR 1819 (HY000): Your password does not satisfy the current policy requirements		</syntaxhighlight>Pada saat menjalankan <syntaxhighlight lang="shell">
			sudo mysql_secure_installation utility
	Pada saat menjalankan		</syntaxhighlight>Memilih salah satu
	sudo mysql_secure_installation utility

	Memilih salah satu
	*<code>LOW</code> Length >= 8 characters.		*<code>LOW</code> Length >= 8 characters.
	*<code>MEDIUM</code> Length >= 8, numeric, mixed case, and special characters.		*<code>MEDIUM</code> Length >= 8, numeric, mixed case, and special characters.
Line 17:		Line 14:

	*Jika memilih MEDIUM buatlah password yang mengandung huruf aphabet kapital dan kecil lalu berikan tanda baca serta angka. Berikut adalah contoh perintahnya		*Jika memilih MEDIUM buatlah password yang mengandung huruf aphabet kapital dan kecil lalu berikan tanda baca serta angka. Berikut adalah contoh perintahnya
	ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Qweewq*#123';		<syntaxhighlight lang="shell">
			ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Qweewq*#123';
			</syntaxhighlight>
	*Perintah berikut digunakan untuk mengubah password pada user root		*Perintah berikut digunakan untuk mengubah password pada user root
	*Jika ingin membuat user baru, berikut adalah perintahnya		*Jika ingin membuat user baru, berikut adalah perintahnya
	create user 'ostechnix'@'localhost' identified by 'Qweewq*#123';		<syntaxhighlight lang="shell">
			create user 'ostechnix'@'localhost' identified by 'Qweewq*#123';
			</syntaxhighlight>

	==Source==		==Source==
Line 27:		Line 27:
	*[https://dev.to/gsudarshan/how-to-install-mysql-and-workbench-on-ubuntu-20-04-localhost-5828 dev.to]		*[https://dev.to/gsudarshan/how-to-install-mysql-and-workbench-on-ubuntu-20-04-localhost-5828 dev.to]
	*[https://stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges stackoverflow.com]		*[https://stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges stackoverflow.com]
			[[Category:SQL]]
			[[Category:Database]]

Kangtain: Created page with "===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements=== Create a database user with a weak password: sudo mysql -u root create user 'ostechnix'@'localhost' identified by 'mypassword'; Terdapat error seperti berikut ERROR 1819 (HY000): Your password does not satisfy the current policy requirements Pada saat menjalankan sudo mysql_secure_installation utility Memilih salah satu *`LOW` Length >= 8 characters...."

2022-03-17T12:27:54Z

Created page with "===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements=== Create a database user with a weak password: sudo mysql -u root create user 'ostechnix'@'localhost' identified by 'mypassword'; Terdapat error seperti berikut ERROR 1819 (HY000): Your password does not satisfy the current policy requirements Pada saat menjalankan sudo mysql_secure_installation utility Memilih salah satu *<code>LOW</code> Length >= 8 characters...."

New page

===Fix – MySQL ERROR 1819 (HY000): Your password does not satisfy the current policy requirements===
Create a database user with a weak password:
sudo mysql -u root

create user 'ostechnix'@'localhost' identified by 'mypassword';

Terdapat error seperti berikut
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Pada saat menjalankan
sudo mysql_secure_installation utility

Memilih salah satu
*<code>LOW</code> Length >= 8 characters.
*<code>MEDIUM</code> Length >= 8, numeric, mixed case, and special characters.
*<code>STRONG</code> Length >= 8, numeric, mixed case, special characters and dictionary file.

*Jika memilih MEDIUM buatlah password yang mengandung huruf aphabet kapital dan kecil lalu berikan tanda baca serta angka. Berikut adalah contoh perintahnya
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Qweewq*#123';

*Perintah berikut digunakan untuk mengubah password pada user root
*Jika ingin membuat user baru, berikut adalah perintahnya
create user 'ostechnix'@'localhost' identified by 'Qweewq*#123';

==Source==
*[https://ostechnix.com/fix-mysql-error-1819-hy000-your-password-does-not-satisfy-the-current-policy-requirements/ ostechnix.com]
*[https://dev.to/gsudarshan/how-to-install-mysql-and-workbench-on-ubuntu-20-04-localhost-5828 dev.to]
*[https://stackoverflow.com/questions/17975120/access-denied-for-user-rootlocalhost-using-password-yes-no-privileges stackoverflow.com]