# 03. Install RDBMS MySQL Server di VPS Linux Ubuntu ### Install MySQL Server di Ubuntu 22.04 untuk install MySQL Server, login terlebih dulu dengan ssh, kemudian update repo [![Screenshot 2023-10-13 at 05.41.55.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-41-55.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-41-55.png) jalankan perintah berikut ```bash sudo apt instal mysql-server ``` [![Screenshot 2023-10-13 at 05.42.32.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-42-32.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-42-32.png) cek status, start, stop, restart service mysql, jalankan perintah berikut ```bash # cek status mysql sudo service mysql status # restart mysql sudo service mysql restart # stop mysql sudo service mysql stop # start mysql sudo service mysql start ``` [![Screenshot 2023-10-13 at 05.43.57.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-43-57.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-43-57.png) ### Login ke Database MySQL untuk login ke mysql, jalankan perintah sudo mysql seperti berikut ```bash # login mysql root pertama kali sudo mysql # login mysql root dengan password sudo mysql -u root -p ``` [![Screenshot 2023-10-13 at 05.45.04.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-45-04.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-45-04.png) ### Merubah Password Root MySQL untuk merubah password root mysql, jalankan perintah berikut ```mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Rahasia.123'; ``` [![Screenshot 2023-10-13 at 05.46.36.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-46-36.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-46-36.png) ### Membuat User Baru MySQL untuk membuat user baru di MySQL jalankan perintah berikut : ```mysql CREATE USER 'naja'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Rahasia.123'; ``` [![Screenshot 2023-10-13 at 05.48.15.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-48-15.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-48-15.png) ### Memberikan privileges full pada user MySQL biasa untuk memberikan full privileges dan grant access pada user biasa, jalankan perintah berikut : ```mysql GRANT ALL PRIVILEGES ON *.* TO 'naja'@'localhost' WITH GRANT OPTION; ``` ### [![Screenshot 2023-10-13 at 05.49.36.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-49-36.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-49-36.png) ### Mengamankan celah dari MySQL untuk mengamankan celah dari MySQL bisa dengan menggunakan script bash dari mysql\_secure\_installation, untuk menjalankan wizardnya ketik perintah berikut : ```bash sudo mysql_secure_installation ``` [![Screenshot 2023-10-13 at 05.50.13.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-50-13.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-50-13.png) pada settingan Validate Password Component bisa pilih "Y" [![Screenshot 2023-10-13 at 05.51.32.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-51-32.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-51-32.png) pada password validation policy bisa dipilih dari LOW/MEDIUM/STRONG [![Screenshot 2023-10-13 at 05.51.52.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-51-52.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-51-52.png) Pada bagian remove anonymous user, kita bisa menghapus dengan menekan "Y" [![Screenshot 2023-10-13 at 05.52.04.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-52-04.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-52-04.png) untuk Remove test database tekan "Y" pada instruksi Remove test database and access to it [![Screenshot 2023-10-13 at 05.52.10.png](https://book.najamudinridha.com/uploads/images/gallery/2023-10/scaled-1680-/screenshot-2023-10-13-at-05-52-10.png)](https://book.najamudinridha.com/uploads/images/gallery/2023-10/screenshot-2023-10-13-at-05-52-10.png)