root@garudacbt:~# apt update && apt upgrade -y
root@garudacbt:~# apt install mysql-server
2. Install mysql client
root@garudacbt:~# apt install mysql-client
3. Mengamankan user root dengan cara memberikan password
root@garudacbt:~# mysql -u root
keluar dari mysql
mysql> exit
4. lakukan restart terhadap mysql
root@garudacbt:~# service mysql restart
5. uji coba login ke mysql dengan root tanpa password tetapi gagal
root@garudacbt:~# mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
6. login ke mysql server dengan user root dan password sukses
root@garudacbt:~# mysql -u root -p
Enter password: Password123#@!
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.34-0ubuntu0.22.04.1 (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.
mysql>
7. Membuat user dan database
mysql> create database garudacbt;
Query OK, 1 row affected (0.01 sec)
mysql> create user 'cbtgaruda'@'localhost' IDENTIFIED WITH caching_sha2_password BY '12345';
Query OK, 0 rows affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON garudacbt.* TO 'cbtgaruda'@'localhost';
Query OK, 0 rows affected (0.01 sec)
mysql> exit;
8. proses pengisian database pada form installer garudacbt
11. Sukses login ke aplikasi tampa mental dan tanpa jamu. semua source hanya dari github cloning dan
app versi 1.5.1
Jasa Instalasi Garuda CBT VPS
Contact Saya : di
WA ---> 0812 6889 5343
Telegram --> @origrata