Step-by-Step Guide

Connect to Your EC2 Instance

Use SSH to connect to your EC2 instance.

ssh -i /path/to/your-key.pem ubuntu@your-ec2-instance-public-dns

Update Package List

Update the package list to ensure you have the latest information about available packages.

sudo apt-get update

Install PHP and Required Extensions

Ensure that PHP and the necessary extensions are installed. If you already have PHP installed, you can skip this step.

sudo apt-get install php php-mbstring php-zip php-gd php-json php-curl php-mysql

Install phpMyAdmin

Install phpMyAdmin using the package manager.

sudo apt-get install phpmyadmin

During the installation, you will be prompted to select the web server that should be automatically configured to run phpMyAdmin. Select apache2 by pressing Space and then Enter.

You will also be asked to configure a database for phpMyAdmin with dbconfig-common. Choose Yes and provide a password for the phpMyAdmin application to register with the database.

Configure Apache

Ensure the phpMyAdmin configuration is included in your Apache configuration. Open the Apache configuration file:

sudo nano /etc/apache2/apache2.conf

Add the following line at the end of the file to include the phpMyAdmin configuration:

apache

Include /etc/phpmyadmin/apache.conf

Save and close the file (Ctrl+X, Y, Enter).

Enable Required Apache Modules

Enable the necessary Apache modules.

sudo a2enmod rewrite

sudo phpenmod mbstring

Restart Apache

Restart Apache to apply the changes.

sudo systemctl restart apache2

Secure phpMyAdmin (Optional)

To secure phpMyAdmin, you can create an .htaccess file to add basic authentication.

sudo nano /usr/share/phpmyadmin/.htaccess

Add the following content:

apache

AuthType Basic

AuthName "Restricted Files"

AuthUserFile /etc/phpmyadmin/.htpasswd

Require valid-user

Save and close the file. Then create the password file and add a user.

sudo htpasswd -c /etc/phpmyadmin/.htpasswd yourusername

Follow the prompts to set a password for the user.

Access phpMyAdmin

You should now be able to access phpMyAdmin by navigating to http://your-ec2-instance-public-dns/phpmyadmin in your web browser. Log in using your MySQL username and password.

Step-by-Step Guide

Wait for the Current Process to Complete

Sometimes, the best approach is to simply wait a few minutes for the current process to complete. If the issue persists, you can proceed with the following steps.

Identify the Process Holding the Lock

Identify the process holding the lock and see if it is still active:

sudo lsof /var/lib/dpkg/lock-frontend

This will show you the process that is currently using the lock. Alternatively, you can use the ps command:

ps aux | grep apt

Terminate the Process (if necessary)

If you determine that the process is not performing any critical operations or it is stuck, you can terminate it. Replace PID with the process ID you found in the previous step:

sudo kill -9 PID

Remove the Lock Files

After terminating the process, you can safely remove the lock files:

sudo rm /var/lib/dpkg/lock-frontend

sudo rm /var/cache/apt/archives/lock

Reconfigure dpkg

Sometimes, dpkg can be left in an inconsistent state. Running the following command can fix this:

sudo dpkg --configure -a

Update and Install Packages Again

Now you should be able to update your package list and install packages without issues:

sudo apt-get update

sudo apt-get install php7.4-mysqli

Step-by-Step Guide

Update Package List

First, ensure that your package list is up-to-date.

sudo apt-get update

Install php-mysqli Extension

Install the php-mysqli extension for PHP 7.4.

sudo apt-get install php7.4-mysqli

Verify Installation

After installation, you should verify that the extension is enabled. You can do this by creating a PHP info file.

sudo nano /var/www/html/info.php

Add the following content to the file:

php

Copy code

<?php

phpinfo();

?>

Save and close the file. Then, navigate to http://your-ec2-instance-public-dns/info.php in your web browser and check for mysqli in the output.

Restart Apache

Restart Apache to apply the changes.

sudo systemctl restart apache2