My SQL administration via command-line in Linux is very difficult job for any newbie system administrator or database administrator, because it contains numerous commands which we cannot remember in our daily life.
Suggested Read: My SQL Basic Database Administration Commands To make My SQL administration much easier we’re introducing a web based My SQL administration tool called Php My Admin, with the help of this tool you can control and manage your database administration via a web browser easily.
Corporate systems need monitoring, backups, updates, as well as system and user management.
Ubuntu (apt), Cent OS, Fedora and Red Hat (rpm/YUM) Linux server administration and desktop systems adminstration are covered in this tutorial.
Here we’ve provided installation of Php My Admin for both the web server’s Apache or Nginx.
So, its up-to you which web server to choose for installation.
RPM is a powerful and mature command-line driven package management system capable of installing, uninstalling, verifying, querying, and updating Unix software packages.
If you don’t have working LAMP or LEMP, you can follow our below articles to setup.
to manage software raid arrays; it assumes you have a good understanding of software RAID and Linux in general, and it will just explain the commands line usage of mdadm.
The examples bellow use RAID1, but they can be adapted for any RAID level the Linux kernel driver supports.
Php My Admin is a web-based interface for managing My SQL / Maria DB databases that is used as a replacement for command-line utilities.
Suggested Read: 20 My SQL (Mysqladmin) Commands for Database Administration in Linux It was written in PHP language, through this application you can do various My SQL administration tasks such as create, drop, alter, delete, import, export, search, query, repair, optimize and run other database management command via browser.