MySQL is a popular database with all developers! It is open source and helps maintain the perfect balance between speed and functionality. That's why in this guide we will show you how to install phpMyAdmin CentOS 7. This is a great tool for managing MySQL databases. VPS Your file will have extra add-ons to increase the quality.
The main reason to use phpMyAdmin is because the main tool for access MySQL is by command line. Not everyone can use the command line, and the lack of a GUI – a graphical user interface – is a pain for novice users. phpMyAdmin supports many tasks on MySQL and MariaDB (a fork of MySQL).
Save up to 77% today and buy Hostinger VPS plan now!
Why use phpMyAdmin?
When you install phpMyAdmin CentOS 7, you will be able to use the new intuitive user interface through the browser instead of using the command line. Through this web-based interface, you can easily manage the database such as manage tables, columns, relations, users, etc., and can execute all SQL statements directly.
To suit the masses of users, phpMyAdmin is translated into 72 different languages and supports both RTL (right-to-left) and LTR (left-to-right) languages.
Some other features of phpMyAdmin:
- create, browse, edit and drop databases, tables, views, columns and indexes
- display multiple result sets via stored procedures or queries
- create, copy, delete, rename and change databases, tables, columns and indexes
- server, database and table maintenance, with server configuration recommendations
- load the text file into the table
You can see more features at Official project page.
How to install phpMyAdmin CentOS 7
Let's go through the Install phpMyAdmin CentOS 7 process step by step.
1. Access VPS
Before we start, we need to access the VPS server using SSH! If you're in trouble, check it out PuTTY tutorial ours!
2. Install Apache Web Server
The first prerequisite of phpMyAdmin is the Apache web server. Use the following command to install Apache on your own CentOS 7 virtual server:
yum install httpd -y
Next, check the status of apache with the command:
systemctl status httpd
Next, we should make sure Apache is running. Enter the server IP address in the browser address bar. You should see the Apache test screen pop up:
3. Install EPEL Repository
phpMyAdmin is included in the EPEL (Extra Packages for Enterprise Linux) repository. To access EPEL, you need to install a special package – epel-release. Use the following command to install epel-release CentOS:
sudo yum install epel-release
Now that the EPEL repo is available, we can proceed to install phpMyAdmin CentOS 7.
4. Install phpMyAdmin CentOS 7
Run the following command:
sudo yum install phpmyadmin
Once the installation is complete, you have to edit the phpMyAdmin configuration file.
5. Configure the phpMyAdmin.conf . file
Editing will ensure that you can access the remote phpMyAdmin client. We will open the file phpMyAdmin.conf in folder /etc/httpd/conf.d/ with vim editor:
vim /etc/httpd/conf.d/phpMyAdmin.conf
Here you will see 4 different request ip strings, matching long IP strings. Default value is 127.0.0.1. Replace that value with the machine IP you will use to access phpMyAdmin. You can use tools like WhatsMyIP to check IP. Save and exit the file by pressing escape and type in :wq.
You can see an example of the file phpMyAdmin.conf under:
6. Restart the Apache Web Server
Next, we will restart the Apache Web server by entering the following command at the command line:
systemctl restart httpd
7. Check if phpMyAdmin is working
Finally, we can open the phpMyAdmin utility by entering the server IP address in the browser's address bar by adding the additional string /phpmyadmin like this – 127.0.0.1/phpmyadmin. There you will see the login screen.
8. Specify phpMyAdmin username and password
Username and password will be in the file config.inc.php. The file will be in the phpMyAdmin installation folder. For us it is /etc/phpMyAdmin.
Open the file with vim editor:
vim config.inc.php
Inside, you can set a username and password, as shown in the screenshot below:
Save and exit the file by pressing esc and :wq as before.
Epilogue
That's all, now you can login! You have finished installing phpMyAdmin CentOS 7.
Once logged in, you will see an intuitive dashboard, which may be very familiar to users of the shared or cloud hosting.
phpMyAdmin is easy to use and acts as the primary solution for all your business database management needs. You don't need to be an experienced database administrator to work with phpMyAdmin. This is the main reason for the popularity of phpMyAdmin. Happy management, and hope to see you in the next article. If you have any questions during the entire phpMyAdmin CentOS 7 installation, let us know by leaving a comment below.
Hai G. is an expert in managing and operating website services. He has many years of experience in VPS, Hosting, technical SEO, CMS. Especially love WordPress and have been using it for over 5 years now. His hobbies are reading, blogging, traveling and mentoring young people to start a business.
Post a Comment
Post a Comment