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...." |
No edit summary |
||
| 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 | |||
</syntaxhighlight><syntaxhighlight lang="shell"> | |||
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 | ||
</syntaxhighlight>Pada saat menjalankan <syntaxhighlight lang="shell"> | |||
sudo mysql_secure_installation utility | |||
Pada saat menjalankan | </syntaxhighlight>Memilih salah satu | ||
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 | ||
<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 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]] | |||
Revision as of 19:39, 25 August 2022
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
LOWLength >= 8 characters.MEDIUMLength >= 8, numeric, mixed case, and special characters.STRONGLength >= 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';