MariaDB root login might give you error on login. Run the following command to obtain and install TLS certificate: sudo certbot -apache -agree-tos -redirect -hsts -staple-ocsp -must-staple -d -email Troubleshoot phpMyAdmin Login Error Run the following command to install the Let’s Encrypt client (certbot) from Ubuntu 20.04 repository: sudo apt install certbot python3-certbot-apache You can now access the phpMyAdmin subdomain: Enable HTTPS on phpMyAdmin with Apache Reload Apache: sudo systemctl reload apache2 Header always set Content-Security-Policy upgrade-insecure-requestsĮnable this virtual host: sudo a2ensite nf Header always set Strict-Transport-Security "max-age=31536000" SSLCertificateKeyFile /etc/letsencrypt/live//privkey.pem
SSLCertificateFile /etc/letsencrypt/live//fullchain.pem If running UFW, do this: sudo ufw allow 80,443/tcpĬreate a DNS record for the subdomain in Route 53 Ĭreate 2 new VirtualHost files nf and nf:įirst create nf with this command and add the info in the file below: sudo nano /etc/apache2/sites-available/nf # pma subdomainĬustomLog $/ combined Sudo iptables -I INPUT -p tcp -dport 443 -j ACCEPT If running on a local computer, open port 80 and 443: sudo iptables -I INPUT -p tcp -dport 80 -j ACCEPT If connection is refused, check your firewall or security group setting. If running on localhost: localhost/phpmyadmin sudo ln -s /etc/phpmyadmin/nf /etc/apache2/conf-available/nfĪgain Now run the following command to check if the /etc/apache2/conf-enabled/nf file exists file /etc/apache2/conf-enabled/nf Accessing phpMyAdmin from a Sub-directory /phpmyadmin You can fix it with the following commands. If this file doesn’t exist on your server, it’s likely that you didn’t select Apache web server in the phpMyAdmin setup wizard. etc/apache2/conf-enabled/nf: symbolic link to. If there’s no error in the installation process, you should see the following command output. Now run the following command to check if the /etc/apache2/conf-enabled/nf file exists. You can check the previleges this user has by logging in with: sudo mysql -u root This creates a DB named phpmyadmin with user phpmyadmin.
#Aws ubuntu install phpmyadmin password#
Then set a password for the phpmyadmin user in MariaDB/MySQL. In the next screen, select Yes to configure a database for phpMyAdmin with dbconfig-common. Then hit Tab key and Enter to confirm your choice. (An asterisk indicates the item is selected). Notes: When it prompts you to select a web server to configure, hit the space bar to select apache2.
#Aws ubuntu install phpmyadmin update#
Download and Install phpMyAdmin on Ubuntu 20.04 sudo apt update It provides a graphical web interface for users to manage MySQL or MariaDB database. PhpMyAdmin is a free and open-source web-based database management tool written in PHP. Install phpMyAdmin with Apache on AWS Ubuntu 20.04
0 kommentar(er)
