INSTALL MYSQL SERVER 8.0 UBUNTU 22.04 LTS DAN MEMBUAT DATABASE GARUDACBT

 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

mysql> use mysql;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'Password123#@!';

mysql> flush privileges;

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

9. Database berhasil diinstall

10. Berhasil instalasi aplikasi sampai finish

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