CentOS Stream 9
Sponsored Link

MariaDB 10.11 : Install phpMyAdmin2024/08/28

 

Install phpMyAdmin to operate MariaDB on web browser from Clients.

[1]

Install and start Apache httpd, refer to here.

[2]

Install PHP, refer to here.

[3] Install phpMyAdmin.
# install from EPEL

[root@www ~]#
dnf --enablerepo=epel -y install phpMyAdmin php-mysqlnd
[root@www ~]#
vi /etc/httpd/conf.d/phpMyAdmin.conf
# line 13 : add access permission for your internal network if you need

Require ip 127.0.0.1 10.0.0.0/24
[root@www ~]#
systemctl reload httpd

[4] If SELinux is enabled, change policy.
[root@www ~]#
setsebool -P httpd_can_network_connect on

[root@www ~]#
setsebool -P httpd_execmem on

[5] Access to [http://(your hostname or IP address)/phpmyadmin/] with web browser from any Clients which are in the Network you set to allow.
Then phpMyAdmin Login form is shown, login with a MariaDB user.
It needs you login as a user that password is set because [Unix_Socket] authentication is enabled by default and users with no password are not login.
[6] If successfully passed authentication, you can operate MariaDB on here.
Matched Content