{"id":3186,"date":"2024-11-30T16:27:49","date_gmt":"2022-07-29T16:34:31","guid":{"rendered":""},"modified":"2025-02-02T00:46:19","modified_gmt":"2025-02-01T23:46:19","slug":"how-to-install-phpmyadmin-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/netcloud24.com\/knowledgebase\/how-to-install-phpmyadmin-on-ubuntu-22-04\/","title":{"rendered":"Linux VPS & VPS Windows Setup Guide | NetCloud24 phpMyAdmin on Ubuntu 22.04"},"content":{"rendered":"

\u00a0<\/p>\n<\/p>\n

\n

\u00a0<\/h1>\n<\/header>\n
\n

phpMyAdmin is a popular open-source tool that allows you to manage MySQL or MariaDB databases using a web interface. It simplifies database management by providing a user-friendly GUI for tasks like creating databases, running queries, and managing users. This guide will walk you through installing phpMyAdmin on Ubuntu 22.04. Whether you’re managing databases locally or on a Windows VPS <\/a>, phpMyAdmin will help streamline your database operations.<\/p>\n

\n

Step 1: Update Your System<\/h2>\n

Before installing phpMyAdmin, ensure that your system is up to date. Run the following commands to update your package list and upgrade installed packages:<\/p>\n

sudo apt update && sudo apt upgrade -y<\/code><\/pre>\n
Keeping your system up to date is critical for security and performance, especially when managing a server on platforms like VPS Windows VPS Servers<\/a>.<\/p>\n<\/section>\n
\n
Step 2: Install Apache, MySQL, and PHP<\/h2>\n
If you haven\u2019t already installed the LAMP (Linux, Apache, MySQL, PHP) stack, you need to do so first. Install Apache, MySQL, and PHP along with the necessary PHP extensions for phpMyAdmin:<\/p>\n
sudo apt install apache2 mysql-server php libapache2-mod-php php-mbstring php-zip php-gd php-json php-curl -y<\/code><\/pre>\n
Start and enable Apache and MySQL to run at boot:<\/p>\n
sudo systemctl start apache2\r\nsudo systemctl enable apache2\r\n\r\nsudo systemctl start mysql\r\nsudo systemctl enable mysql<\/code><\/pre>\n<\/section>\n
\n
Step 3: Install phpMyAdmin<\/h2>\n
phpMyAdmin is available in the default Ubuntu repository. Install it using the following command:<\/p>\n
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl -y<\/code><\/pre>\n
During the installation, you will be prompted to select the web server that should be automatically configured to run phpMyAdmin. Select apache2<\/strong> using the spacebar and press Enter<\/strong>.<\/p>\n
Next, you\u2019ll be prompted to configure the phpMyAdmin database. Choose Yes<\/strong> and then set a password for the phpMyAdmin application.<\/p>\n<\/section>\n
\n
Step 4: Enable PHP Extensions<\/h2>\n
Enable the required PHP extensions for phpMyAdmin to function properly:<\/p>\n
sudo phpenmod mbstring<\/code><\/pre>\n
Restart Apache to apply the changes:<\/p>\n
sudo systemctl restart apache2<\/code><\/pre>\n<\/section>\n
\n
Step 5: Configure phpMyAdmin<\/h2>\n
phpMyAdmin is now installed, but you need to configure MySQL to allow phpMyAdmin to manage databases. Log in to MySQL:<\/p>\n
sudo mysql -u root -p<\/code><\/pre>\n
Create a new MySQL user and grant it the necessary privileges:<\/p>\n
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'your_password';\r\nGRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;\r\nFLUSH PRIVILEGES;\r\nEXIT;<\/code><\/pre>\n
Replace your_password<\/code> with a secure password of your choice.<\/p>\n<\/section>\n
\n
Step 6: Access phpMyAdmin<\/h2>\n
You can now access phpMyAdmin by navigating to http:\/\/your_server_ip\/phpmyadmin<\/code> in your web browser. Use the MySQL credentials you created earlier to log in.<\/p>\n
If you\u2019re running this setup on a Windows VPS <\/a> server, phpMyAdmin will provide a reliable interface for managing databases from anywhere.<\/p>\n<\/section>\n
\n
Step 7: Secure phpMyAdmin (Optional)<\/h2>\n
phpMyAdmin is a powerful tool, but it can be a target for attacks if not properly secured. One way to add security is by setting up an additional authentication layer using Apache.<\/p>\n
First, create a password file using the htpasswd<\/code> utility:<\/p>\n
sudo htpasswd -c \/etc\/phpmyadmin\/.htpasswd your_username<\/code><\/pre>\n
After creating the password file, edit the phpMyAdmin Apache configuration file:<\/p>\n
sudo nano \/etc\/apache2\/conf-available\/phpmyadmin.conf<\/code><\/pre>\n
Add the following lines to the configuration file to enable basic authentication:<\/p>\n
<Directory \/usr\/share\/phpmyadmin>\r\n    AuthType Basic\r\n    AuthName \"Restricted Access\"\r\n    AuthUserFile \/etc\/phpmyadmin\/.htpasswd\r\n    Require valid-user\r\n<\/Directory><\/code><\/pre>\n
Save and close the file, then restart Apache to apply the changes:<\/p>\n
sudo systemctl restart apache2<\/code><\/pre>\n
Now, when you access phpMyAdmin, you will be prompted to enter the additional username and password before accessing the login page.<\/p>\n<\/section>\n