To install an unmanaged VPS with the MySQL + phpMyAdmin template, follow these steps:
Access https://login.virtualservers.pt/ and enter your login credentials. Click Login.
After logging in, you will be directed to the VPS overview area. Identify the VPS where you want to install the template (if you have more than one) and click Manage.
Click Reinstall to start the reinstallation process.
Select the MySQL + phpMyAdmin option and click Reinstall again.
A confirmation message will appear. Click Yes to confirm the reinstallation. Warning: all existing data on the VPS will be erased, so make sure to back up any important information beforehand.
On the first boot, a temporary random MySQL password will be generated. To view it, use the command:
grep -i pass /var/log/mysqld.log
Run mysql_secure_installation to secure the database.
Access phpMyAdmin via the link:
Use the MySQL root credentials or any created database user to log in.
For security, you should configure a new blowfish secret in the file:
/var/www/html/pma/config.inc.php
To generate a blowfish secret, you can use the online generator available at http://www.passwordtool.hu/blowfish-password-hash-generator.
Following these steps, your VPS will be ready to manage databases securely through MySQL and phpMyAdmin.
