Skip to main content

How To Install phpMyAdmin on CentOS 7 Server

You may need to do the following first:

How To Install PHP On CentOS 7


The EPEL repository can be made available to your server by installing a special package called epel-release. This will reconfigure your repository list and give you access to the EPEL packages.

To install, just type:

sudo yum install epel-release

Now that the EPEL repo is configured, you can install the phpMyAdmin package using the yum packaging system by typing:

sudo yum install phpmyadmin

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

Change any lines that read Require ip 127.0.0.1 or Allow from 127.0.0.1 to refer to your connection's IP address.

#  sed 's/127.0.0.1/127.0.0.1 192.168.2.88/g' < /etc/httpd/conf.d/phpMyAdmin.conf > /etc/httpd/conf.d/phpMyAdmin.conf.new

You may also need to change mysql server ip:

sudo vi /etc/phpMyAdmin/config.inc.php

sudo systemctl restart httpd.service

visit:
your-server/phpMyAdmin/index.php

If you encounter:

Can't login to remote MariaDB server


sudo getsebool -a | grep httpd
to check whether you can connect to db from http.

sudo setsebool -P httpd_can_network_connect_db on
Post a Comment

Popular posts from this blog

How to reset password of Jenkins

Reset password of JenkinsPrefer way, No securities were harmedSee also:
What is Jenkins' initial admin password

To reset it without disabling security if you're using matrix permissions (probably easily adaptable to other login methods): In config.xml, set disableSignup to false.Restart Jenkins.Go to the Jenkins web page and sign up with a new user.In config.xml, duplicate one of the <permission>hudson.model.Hudson.Administer:username</permission> lines and replace username with the new user.If it's a private server, set disableSignup back to true in config.xml.Restart Jenkins.Go to the Jenkins web page and log in as the new user.Reset the password of the original user.Log in as the original user. Optional cleanup: Delete the new user.Delete the temporary <permission> line in config.xml. Alternative way:
ssh to the server, disable authentication, set the password via the Jenkins Web UI, then enable authentication.