PhpMyAdmin

Ensure you have:

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

+++++++++++Centos-9+++++++++

https://wiki.crowncloud.net/?How_to_Install_phpMyAdmin_on_CentOS_Stream_9

sudo dnf install mariadb-server mariadb -y

sudo systemctl start mariadb

sudo systemctl enable mariadb

sudo systemctl status mariadb

sudo mysql

MariaDB [(none)]> CREATE DATABASE my_database;

MariaDB [(none)]> CREATE USER ‘my_admin’@’localhost’ IDENTIFIED BY ‘password’;

MariaDB [(none)]> GRANT ALL PRIVILEGES ON my_database.* TO ‘my_admin’@’localhost’;

MariaDB [(none)]> FLUSH PRIVILEGES;

MariaDB [(none)]> EXIT;

sudo systemctl restart mariadb

sudo mysql -u root -p

sudo dnf config-manager –set-enabled crb

sudo dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm -y

sudo dnf install https://dl.fedoraproject.org/pub/epel/epel-next-release-latest-9.noarch.rpm -y

sudo dnf install phpmyadmin -y

sudo systemctl restart httpd

sudo systemctl enable httpd

sudo systemctl start httpd

sudo vi /etc/httpd/conf.d/phpMyAdmin.conf

Add the “Require all granted” line under the “Require local” line

# dangerous unless properly secured by SSL

Alias /phpMyAdmin /usr/share/phpMyAdmin

Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>

   AddDefaultCharset UTF-8

   Require local

   Require all granted

</Directory>

<Directory /usr/share/phpMyAdmin/setup/>

   Require local

</Directory>

sudo systemctl restart httpd

sudo systemctl status httpd

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