Remove , hapus password root mysql , ini berfungsi masuk mysql tanpa password dan berguna saat backup automatis cronjob mysqldump karena kalau root ada password mysqdump akan gagal / failed.
hanya ketikan : mysql -u root
Pertama
Silahkan login dengan password : mysql -u root -p > masukan pasword, setelah masuk langsung hapus komponen, dengan ketikan:
UNINSTALL COMPONENT "file://component_validate_password";
Hasil : Query OK, 0 rows affected (0.00 sec)
Kedua
Seting / hapus password untuk root , ketikan :
mysql> set password for root@localhost='';
Hasil : Query OK, 0 rows affected (0.00 sec)
Silahkan keluar mysql ketikan : quit;
Coba langsung masuk ke ketikan:
mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 333
Server version: 8.0.33-0ubuntu0.20.04.2 (Ubuntu)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
__SELESAI