MySQL Workbench: Difference between revisions
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...." |
m Kangtain moved page Software/MySQL Workbench to MySQL Workbench over redirect |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
'''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 == | |||
Create a database user with a weak password: | Create a database user with a weak password: | ||
<syntaxhighlight lang="shell"> | |||
sudo mysql -u root | |||
</syntaxhighlight> | |||
<syntaxhighlight lang="shell"> | |||
create user 'ostechnix'@'localhost' identified by 'mypassword'; | |||
</syntaxhighlight> | |||
Terdapat error seperti berikut | Terdapat error seperti berikut | ||
Pada saat menjalankan | <syntaxhighlight lang="shell"> | ||
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements | |||
</syntaxhighlight> | |||
Pada saat menjalankan | |||
<syntaxhighlight lang="shell"> | |||
sudo mysql_secure_installation utility | |||
</syntaxhighlight> | |||
Memilih salah satu | Memilih salah satu | ||
| Line 15: | Line 28: | ||
*<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 | |||
<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 | ||
<syntaxhighlight lang="shell"> | |||
create user 'ostechnix'@'localhost' identified by 'Qweewq*#123'; | |||
</syntaxhighlight> | |||
==Source== | ==Source== | ||
| Line 27: | Line 45: | ||
*[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]] | |||