Cara Install Phpmyadmin di Ubuntu server 20.04

Referensi : https://tecadmin.net/install-phpmyadmin-ubuntu-20-04/
https://www.cyberciti.biz/faq/how-to-create-mysql-admin-user-superuser-account/

Step 2 – Install phpMyAdmin on Ubuntu 20.04

wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-all-languages.zip 
unzip phpMyAdmin-5.1.1-all-languages.zip 
mv phpMyAdmin-5.1.1-all-languages /usr/share/phpmyadmin
mkdir /usr/share/phpmyadmin/tmp 
chown -R www-data:www-data /usr/share/phpmyadmin 
chmod 777 /usr/share/phpmyadmin/tmp  

Step 3 – Configure phpMyAdmin

sudo nano /etc/apache/conf-available/phpmyadmin.conf 
Update file phpmyadmin.conf dengan script berikut

 Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin/>
   AddDefaultCharset UTF-8
   <IfModule mod_authz_core.c>
      <RequireAny>
      Require all granted
     </RequireAny>
   </IfModule>
</Directory>

<Directory /usr/share/phpmyadmin/setup/>
   <IfModule mod_authz_core.c>
     <RequireAny>
       Require all granted
     </RequireAny>
   </IfModule>
</Directory>

After making all the changes, make sure to start the Apache service to reload all settings.

sudo a2enconf phpmyadmin 
sudo systemctl restart apache2 

Step 4 – Access phpMyAdmin

http://your-server-ip-domain/phpmyadmin
Buat super user untuk akses phpmyadmin dari luar server
sudo mysql -p -u root
CREATE USER 'smpdbos'@'%' IDENTIFIED BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'smpdbos'@'%' WITH GRAND OPTION;