Tuesday, November 25, 2025

MariaDB 10.11 : Install phpMyAdmin

 

MariaDB 10.11 : Install phpMyAdmin

 

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.


No comments:

Post a Comment