Accessing phpMyAdmin in Vesta Control Panel

Vesta Control Panel (VestaCP) includes phpMyAdmin, a web-based tool for managing MySQL or MariaDB databases. Here is how to access, configure, and troubleshoot phpMyAdmin in VestaCP.

For closely related VestaCP and phpMyAdmin topics, see VestaCP — Missing Language Files, "No Language Defined" Error in VestaCP, Using phpMyAdmin for a Website, and phpMyAdmin "Error During Session Start".

The default phpMyAdmin URL in VestaCP is:

http://your-server-ip/phpmyadmin

If you have changed your server domain or added SSL, it might be:

https://your-domain.com/phpmyadmin

1. Open the configuration file:

sudo nano /etc/nginx/conf.d/phpmyadmin.conf

2. Modify the location block to change the URL. For example:

location /custom-phpmyadmin-url {

    alias /usr/share/phpMyAdmin;

    index index.php;

}

3. Save the file and restart Nginx:

sudo systemctl restart nginx

1. Install a valid SSL certificate for your server (e.g., via Let's Encrypt in VestaCP).
2. Force SSL redirection for phpMyAdmin:
   • Edit the Nginx configuration file:

   sudo nano /etc/nginx/conf.d/phpmyadmin.conf

   • Add:

server {

    listen 443 ssl;

    server_name your-domain.com;



    ssl_certificate /path/to/ssl.crt;

    ssl_certificate_key /path/to/ssl.key;



    location /phpmyadmin {

        alias /usr/share/phpMyAdmin;

        index index.php;

    }

}

3. Save and restart Nginx:

sudo systemctl restart nginx