In this article, let’s check how to access PhpMyAdmin in cPanel.
PhpMyAdmin is a free web application that provides GUI for working with the MySQL database management system. It is used to perform administration tasks like creating a database, running queries, and adding user accounts. It is compactable for almost any operating system. This tool is written in PHP that is intended to handle the administration of MySQL or MariaDB database servers.
Different options for managing the databases using phpMyAdmin
1) Structure: It is the basic design of the database. Assists to organize your schemas, tables, and columns.
2) SQL: Structured query language used to manage data in the database management system. It assists the administrator to runs SQL query/queries on MySQL or MariaDB servers.
3) Search Searches words or values inside the database tables.
4) Query: Query is a request for data or information from a database table or combination of tables. SQL defines a set of commands, such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, and many more.
5) Export: Exports database in different formats such as CSV, PDF, SQL, XML, Text, etc.
6) Import: Imports database in different formats such as OpenDocument Spreadsheet, CSV, SQL, ESRI Shapefile, XML.
7) Operations: There are various operations that you can execute on the whole database and on a separate table.
Sometimes we are unable to use phpMyAdmin in cPanel. The most common error every user gets with MariaDB is:
In order to investigate the issue in detail, we have to log in to the server (logged as root using SSH) and execute the command given below.
After executing the command, you will see the error message on the console just like this.
Follow the below steps to resolve this issue.
1) log in to the server as root user via SSH.
2) Start MySQL using the following command.
3) Navigate to the following location.
4) Here you can see a file named tc.log. It is a text file, along with a list of binary logs. It was created with a fresh installation of MariaDB. Rename the file to some other name like tc.log-bk
5) then start MySQL again.
Now, you would be able to access PHPMyAdmin from cPanel. If you are still facing this issue, please contact our support staff let our experts solve the issue on your behalf.
