Install phpMyAdmin on CentOS 7
PhpMyAdmin is a convenient way to manage MySQL/MariaDB for those who prefer a browser-based interface over the traditional command-line interface. Learn how to install and use phpMyAdmin on a Cloud Server with Linux (CentOS 7).
Requirements
- A Cloud Server with Linux.
- MySQL/MariaDB installed and running.
- PHP installed and running.
Free Cloud Server Trial from IONOS
Try out a Cloud Server for free now - test your IONOS Cloud Server for 30 days!
PHP and MySQL/MariaDB are installed and running on a Standard Linux installation by default. If your server was created with a Minimal installation, you will need to install and configure PHP and MySQL/MariaDB before you proceed.
To install phpMyAdmin on CentOS 7, first install the EPEL repository:
sudo yum install epel-release
Then install phpMyAdmin with the command:
sudo yum install phpmyadmin
Next, you will need to edit the configuration file to allow access from your desktop computer. To find your IP address, you can simply search Google for "What's my IP address."
Open the configuration file for editing:
sudo nano /etc/httpd/conf.d/phpMyAdmin.conf
Change the lines which read:
Require ip 127.0.0.1
Allow from 127.0.0.1
These lines are repeated, so you will need to change four lines in total.
Change the IP address 127.0.0.1 to your IP address:
Require ip 192.168.0.1
Allow from 192.168.0.1
Then save and exit the file.
Restart Apache for the changes to take effect:
systemctl restart httpd You can now access phpMyAdmin at "https://www.example.com/phpmyadmin".
Related articles
Add an Apache Virtual Host on CentOS 7 and Ubuntu 16.04
Learn how to add a virtual host to an Apache web server. Virtual hosts allow you to host multiple separate websites on the same server, with a separate set of directories for each website.
Install and use Pip on CentOS 7
Pip is a package management system for Python. We recommend the use of Pip, as it is the officially recognized tool for installing Python packages, according to the official Python Software Foundation. Learn how to install and use Pip on CentOS 7 Cloud Servers.
Upgrade PHP From 5.4 to 7.0 on a CentOS 7 Cloud Server
The default version of PHP available on a new Cloud Server running CentOS 7 is version 5.4. Learn how to upgrade this to PHP 7.0. You will need to perform the upgrade by hand, since PHP 7 is not available in the standard CentOS 7 `yum` repository, because it is not considered stable.
agsandrewShutterstock What is CentOS?
Finding a suitable operating system that meets your own requirements is usually not very difficult in the private sector. Most of the time, it’s just down to personal taste whether you favor Windows, macOS, or Linux. The search for a system solution for enterprise and server environments is far more difficult and complex. When selecting, factors such as long-term support, security, and cost play a…
How to install phpMyAdmin in a few steps
Almost every website works with databases. However, website administration can be pretty complicated sometimes. A graphical user interface may help, especially if you’re not familiar with working in the command line. The phpMyAdmin tool offers a graphical user interface. Our article will show you how to install phpMyAdmin.
