PhpMyAdmin

Ensure you have:

• A LAMP stack (Linux, Apache, MySQL/MariaDB, PHP) installed.

https://docs.vultr.com/how-to-install-phpmyadmin-on-ubuntu-24-04

sudo apt update

sudo apt install mysql-server -y

sudo mysql

sudo systemctl restart mysql

sudo systemctl enable mysql

sudo systemctl status mysql

mysql> CREATE DATABASE my_database;

mysql> CREATE USER ‘my_admin’@’localhost’ IDENTIFIED BY ‘password’;

mysql> GRANT ALL PRIVILEGES ON my_database.* TO ‘my_admin’@’localhost’;

mysql> FLUSH PRIVILEGES;

mysql> EXIT;

sudo apt update

sudo apt install php php-mysql php-mbstring php-json php-xml php-curl php-zip php-common -y

sudo apt install phpmyadmin -y

dpkg -l | awk ‘/phpmyadmin / {print}’

sudo a2enconf phpmyadmin.conf

Output:

Conf phpmyadmin already enabled

sudo systemctl restart apache2

sudo systemctl enable apache2

sudo systemctl status apache2

Getting Started After Deploying PhpMyAdmin.

PhpMyAdmin MOTD

On your first SSH login to the VM or launch of the VM console of your PhpMyAdmin VM 1-Click; you will be greeted by a message of the day which includes the admin password for your PhpMyAdmin instance:

PhpMyAdmin passwords location

If for any reason, you are unable to access the message of the day, you can get the admin password by simply

Reading the /root/.neoncloud_password file in your VM:

PhpMyAdmin login screen

With an admin password, you can now access your PhpMyAdmin instance, by visiting http://<your_server_IP>/phpmyadmin:

Username:  my_admin

Password:  password