https://wiki.smpyppksantodonboscofakfak.sch.id/index.php?action=history&feed=atom&title=Cara_Install_Phpmyadmin_di_Ubuntu_server_20.04
Cara Install Phpmyadmin di Ubuntu server 20.04 - Revision history
2026-05-10T14:27:33Z
Revision history for this page on the wiki
MediaWiki 1.43.1
https://wiki.smpyppksantodonboscofakfak.sch.id/index.php?title=Cara_Install_Phpmyadmin_di_Ubuntu_server_20.04&diff=41&oldid=prev
Smpdbos: 1 revision imported
2023-02-07T22:29:15Z
<p>1 revision imported</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:29, 7 February 2023</td>
</tr><tr><td colspan="4" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div>
</td></tr>
<!-- diff cache key smpyppks_mw3525-mwsh_:diff:1.41:old-40:rev-41 -->
</table>
Smpdbos
https://wiki.smpyppksantodonboscofakfak.sch.id/index.php?title=Cara_Install_Phpmyadmin_di_Ubuntu_server_20.04&diff=40&oldid=prev
dw>Admin at 02:33, 21 December 2022
2022-12-21T02:33:27Z
<p></p>
<p><b>New page</b></p><div> Referensi : https://tecadmin.net/install-phpmyadmin-ubuntu-20-04/<br />
https://www.cyberciti.biz/faq/how-to-create-mysql-admin-user-superuser-account/<br />
<br />
==Step 1 – Install Apache and PHP==<br />
==Step 2 – Install phpMyAdmin on Ubuntu 20.04==<br />
wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-all-languages.zip <br />
unzip phpMyAdmin-5.1.1-all-languages.zip <br />
mv phpMyAdmin-5.1.1-all-languages /usr/share/phpmyadmin<br />
mkdir /usr/share/phpmyadmin/tmp <br />
chown -R www-data:www-data /usr/share/phpmyadmin <br />
chmod 777 /usr/share/phpmyadmin/tmp <br />
<br />
==Step 3 – Configure phpMyAdmin==<br />
sudo nano /etc/apache/conf-available/phpmyadmin.conf <br />
Update file phpmyadmin.conf dengan script berikut<br />
<br />
Alias /phpmyadmin /usr/share/phpmyadmin<br />
Alias /phpMyAdmin /usr/share/phpmyadmin<br />
<br />
<Directory /usr/share/phpmyadmin/><br />
AddDefaultCharset UTF-8<br />
<IfModule mod_authz_core.c><br />
<RequireAny><br />
Require all granted<br />
</RequireAny><br />
</IfModule><br />
</Directory><br />
<br />
<Directory /usr/share/phpmyadmin/setup/><br />
<IfModule mod_authz_core.c><br />
<RequireAny><br />
Require all granted<br />
</RequireAny><br />
</IfModule><br />
</Directory><br />
<br />
After making all the changes, make sure to start the Apache service to reload all settings.<br />
<br />
sudo a2enconf phpmyadmin <br />
sudo systemctl restart apache2 <br />
<br />
==Step 4 – Access phpMyAdmin==<br />
http://your-server-ip-domain/phpmyadmin<br />
Buat super user untuk akses phpmyadmin dari luar server<br />
sudo mysql -p -u root<br />
CREATE USER 'smpdbos'@'%' IDENTIFIED BY '123456';<br />
GRANT ALL PRIVILEGES ON *.* TO 'smpdbos'@'%' WITH GRAND OPTION;</div>
dw>Admin