What is PhpMyAdmin?

Managing databases is made easier when you have an intuitive interface.PhpMyAdmin is a web interface that will give you the capabilities to manage databases from any gadget that runs a modern web browser. It is a free and well-known tool that is written in PHP programming language to help in managing MariaDB and MySQL databases plus their derivatives over the web. Additionally, PhpMyAdmin was released in the year 1998, September and now it is widely used around the globe. In this guide, we will interact with PhpMyAdmin by installing and using it on Void Linux.

PhpMyAdmin has a million users which makes it a popular tool. Users who include database administrators, developers, and others, use PhpMyAdmin to create and test queries and manage databases. Programmers interact with this feature-rich tool to create complicated SQL queries (Structure Query Language) on a web interface. With PhpMyAdmin, you can employ more than one database system with its connected servers and node units.

Features of PhpMyAdmin

  • Web-Based: PhpMyAdmin offers a Web-based interface available on all platforms that support a web browser.
  • Handling complex queries: It makes it easy to create and run complex queries on the user’s interface. Enables a user to create complex queries using Query-by-example (QBE)
  • Multi-Server: With PhpMyAdmin, you can run multiple servers at a time.
  • Supports MySQL features: Some of the features are; create, copy, rename, drop and alter databases, tables, indexes, and fields. Also, another MySQL feature supported by PhpMyAdmin is managing stored procedures and triggers.
  • Allows import of data from CSV and SQL.
  • Exporting of data: With PhpMyAdmin, you can export data using various formats such as CSV, SQL, XML, PDF, Word, and others.
  • PhpMyAdmin is translated into about 72 languages and supports RTL and LTR languages. This makes it easy for a wide range of people to interact with the software.
  • PhpMyAdmin allows searching globally in a database or a subset of it.
  • Users of PhpMyAdmin can edit, execute, and bookmark SQL statements.

Prerequisite

For PhpMy Admin to work on Void Linux, consider installing LAMP Stack.

Installing PhpMyAdmin on Void Linux

Before we start installing phpMyAdmin, let’s update the Void Linux repositories.

sudo xbps-install -Su

Then install PHPMyAdmin with the following command.

sudo xbps-install apache phpMyAdmin

Edit the phpMyAdmin configuration file using a text editor such as Vim or Nano.

sudo vim /etc/apache/extra/phpmyadmin.conf

Once the configuration file opens, add the following text.

Alias /phpmyadmin "/usr/share/webapps/phpMyAdmin"
<Directory "/usr/share/webapps/phpMyAdmin">
    DirectoryIndex index.php
    AllowOverride All
    Options FollowSymlinks
    Require all granted
</Directory>

Open the Apache configuration file to include phpMyAdmin in it.

sudo vim /etc/apache/httpd.conf

Inside the Apache configuration file, add the following lines.

#... phpMyAdmin configuration
Include /etc/apache/extra/phpmyadmin.conf

More configurations include installing the PHP-MySQL package to make phpMyAdmin work smoothly.

sudo xbps-install php-mysql

Proceed by editing the file below.

sudo vim /etc/php/php.ini

Once the file above has opened, scroll down until you find the extension=mysqli statement.

Then uncomment the extension=mysqli line.

extension=mysqli

Restart the Apache Web server and myqsld to ensure the changes are effective.

sudo sv restart apache mysqld

Access and Using PhpMyAdmin on Void Linux

To open phpMyAdmin, head over to your browser and type localhost/phpmyadmin then click on the enter button. PhpMyAdmin will open as shown below. Remember that, when installing MariaDB, we changed or retained the root password. Use the password you set and root as the username. Then click on the go button to log in.

Creating Database on PhpMyAdmin

Once you have logged in, the phpMyAdmin interface will be displayed. Click on create database button; fill in the name you prefer for your database and click on Create button. Your database will be created successfully.

Create Table

From the phpMyAdmin interface, click on the SQL tab.

Then specify the data parameters by typing text inside the blank space. Below is an example:

CREATE TABLE trainers (
    id INT NOT NULL PRIMARY KEY, 
    first_name VARCHAR (255) NOT NULL,
    last_name VARCHAR (255) NOT NULL,
    role VARCHAR (255) NOT NULL
); 

Click on the go button and the table will be created successfully.

From the structure tab on PhpMyAdmin, view the table you have created.

Create Table Data

Next, insert data on the table you have created from the SQL tab.

INSERT INTO trainers
  ( id, first_name, last_name, role )
VALUES
  (123, 'Mark', 'Davis', 'Supervisor'), 
  (456, 'Mary', 'Ndungu', 'Assistant'), 
  (789, 'Elon', 'Jayden', 'Trainer1'),
  (101, 'Kate', 'Cooper', 'Trainer2');

In this case, the INSERT INTO Statement is used to create rows with data. Click on the go button to insert data on the table.

Then, click on the table to view the rows you have created.

Conclusion

PhpMyAdmin is a special tool with a user-friendly interface and many more advantages. Note that, its main purpose is to manage and administer database application systems such as MySQL or MariaDB.From this guide, we have seen how you can install and use phpMyAdmin on Void Linux. Hence, continue using it on your system and enjoy the benefits that phpMyAdmin offers. If you have any questions, leave a message in the comment section.

More Guides include:

LEAVE A REPLY

Please enter your comment!
Please enter your name here