Konfigurasi PHPMyadmin

Langkah 5 : Pemasangan PHPmyadmin
   

sudo apt install phpmyadmin php-mbstring php-gettext

Langkah 5.1 : paparan konfigurasi phpmyadmin

Langkah 8.1.1

• Pilih apache2 sebagai webserver dan tekan OK

Langkah 5.1.2

• pilih YES

Langkah 5.1.3

• Masukkan password bagi login phpmyadmin ke database

Langkah 5.2 : Pengesahan dan Keistimewaan Pengguna

- Untuk versi terkini PHPMyadmin, ubuntu menggunakan nama pengguna : phpmyadmin

- untuk memberi akses kepada pengguna : root, sila ikuti langkah ini

Langkah 5.2.1

sudo mysql

Langkah 5.2.2
SELECT user,authentication_string,plugin,host FROM mysql.user;

Output
+------------------+-------------------------------------------+-----------------------+-----------+
| user             | authentication_string                     | plugin                | host      |
+------------------+-------------------------------------------+-----------------------+-----------+
| root             |                                           | auth_socket           | localhost |
| mysql.session    | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| mysql.sys        | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| debian-sys-maint | *8486437DE5F65ADC4A4B001CA591363B64746D4C | mysql_native_password | localhost |
| phpmyadmin       | *5FD2B7524254B7F81B32873B1EA6D681503A5CA9 | mysql_native_password | localhost |
+------------------+-------------------------------------------+-----------------------+-----------+

Tukar perkataan password bagi arahan dibawah :

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Untuk memastikan password dimasukkan ke database

       FLUSH PRIVILEGES;

Untuk menyemak password root telah dimasukkan ke database,
      SELECT user,authentication_string,plugin,host FROM mysql.user;

Output
+------------------+-------------------------------------------+-----------------------+-----------+
| user             | authentication_string                     | plugin                | host      |
+------------------+-------------------------------------------+-----------------------+-----------+
| root             | *DE06E242B88EFB1FE4B5083587C260BACB2A6158 | mysql_native_password | localhost |
| mysql.session    | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| mysql.sys        | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | mysql_native_password | localhost |
| debian-sys-maint | *8486437DE5F65ADC4A4B001CA591363B64746D4C | mysql_native_password | localhost |
| phpmyadmin       | *5FD2B7524254B7F81B32873B1EA6D681503A5CA9 | mysql_native_password | localhost |
+------------------+-------------------------------------------+-----------------------+-----------+
5 rows in set (0.00 sec)

Pada pelayar anda, taipkan localhost/phpmyadmin dan kemudian log masuk.....