phpMyAdmin – Installation, Configuration & Usage

Table of Contents: What Is phpMyAdmin? Install phpMyAdmin on Your Server Access phpMyAdmin Secure phpMyAdmin (Important for Security) Manage Databases Using phpMyAdmin Troubleshooting Common Issues Summary

phpMyAdmin Database Management Interface

What Is phpMyAdmin?

phpMyAdmin is a PHP-based MySQL/MariaDB database management tool that allows users to:

Create, edit, delete databases & tables
Run SQL queries
Manage users & privileges
Import/export databases
Backup & restore MySQL databases

phpMyAdmin is useful for web hosting, development, and managing WordPress, Joomla, or other CMS databases.

Install phpMyAdmin on Your Server

Install phpMyAdmin on Ubuntu/Debian

sudo apt update
sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl -y

Install phpMyAdmin on CentOS/RHEL

sudo yum install epel-release -y
sudo yum install phpmyadmin -y

After installation, restart Apache or Nginx:

sudo systemctl restart apache2  # Ubuntu/Debian
sudo systemctl restart httpd  # CentOS/RHEL

Access phpMyAdmin

Once installed, access phpMyAdmin in a browser:

http://yourserver-ip/phpmyadmin
or
http://yourdomain.com/phpmyadmin

Security Warning: Never leave phpMyAdmin accessible without proper security measures.

Secure phpMyAdmin (Important for Security)

By default, phpMyAdmin is publicly accessible, making it vulnerable to attacks. Secure it with:

Password Protect with .htaccess (Apache)

sudo nano /etc/apache2/conf-available/phpmyadmin.conf

Add:

<Directory /usr/share/phpmyadmin>
    AllowOverride All
</Directory>

Save & restart:

sudo systemctl restart apache2

Then, create an .htpasswd file:

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

Now, phpMyAdmin will require a second password before login.

Change phpMyAdmin URL

Instead of using /phpmyadmin, rename it for extra security.

sudo mv /usr/share/phpmyadmin /usr/share/securephpmyadmin

Update Apache/Nginx config to reflect the new path.

Manage Databases Using phpMyAdmin

Create a New Database

Log in to phpMyAdmin.
Click "Databases".
Enter the database name and click "Create".

Import a Database

Click "Import".
Select a .sql file from your computer.
Click "Go".

Run SQL Queries

Click "SQL".
Enter a query, e.g.:
SELECT * FROM users;
Click "Go".

Troubleshooting Common Issues

"Access Denied for User 'root'@'localhost'"

Run:

sudo mysql -u root -p

Then reset the password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourNewPassword';
FLUSH PRIVILEGES;
EXIT;

phpMyAdmin Not Found (404 or Forbidden)

Ensure Apache/Nginx is configured correctly:

sudo ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin
sudo systemctl restart apache2

Summary

Task	Command/Steps
Install phpMyAdmin	`sudo apt install phpmyadmin -y`
Access phpMyAdmin	`http://yourserver-ip/phpmyadmin`
Secure phpMyAdmin	Use .htaccess, change the URL
Create Database	Click "Databases" > Create
Import Database	Click "Import" > Upload .sql file
Run SQL Query	Click "SQL" > Enter query
Fix Access Denied	Reset root password in MySQL

Now you have phpMyAdmin running and secured!

phpMyAdmin – Installation, Configuration & Usage

What Is phpMyAdmin?

Install phpMyAdmin on Your Server

Install phpMyAdmin on Ubuntu/Debian

Install phpMyAdmin on CentOS/RHEL

Access phpMyAdmin

Secure phpMyAdmin (Important for Security)

Password Protect with .htaccess (Apache)

Change phpMyAdmin URL

Manage Databases Using phpMyAdmin

Create a New Database

Import a Database

Run SQL Queries

Troubleshooting Common Issues

"Access Denied for User 'root'@'localhost'"

phpMyAdmin Not Found (404 or Forbidden)

Summary

High-Availability Cloud VDS

Hosting

Cloud Solution

For You

VDS

Website Builders

Our services

Client Area

Select Currency

phpMyAdmin – Installation, Configuration & Usage

What Is phpMyAdmin?

Install phpMyAdmin on Your Server

Install phpMyAdmin on Ubuntu/Debian

Install phpMyAdmin on CentOS/RHEL

Access phpMyAdmin

Secure phpMyAdmin (Important for Security)

Password Protect with .htaccess (Apache)

Change phpMyAdmin URL

Manage Databases Using phpMyAdmin

Create a New Database

Import a Database

Run SQL Queries

Troubleshooting Common Issues

"Access Denied for User 'root'@'localhost'"

phpMyAdmin Not Found (404 or Forbidden)

Summary

High-Availability Cloud VDS

Hosting

Cloud Solution

For You

VDS

Website Builders

Our services

Client Area

Выберите валюту