How to access and manage phpMyAdmin?

 

Administration of your database through phpMyAdmin

 

phpMyAdmin is a tool written in PHP to manage MySQL administration through the web. The databases must be created in cPanel or Plesk, but phpMyAdmin can delete databases, create, alter tables, delete, edit, add fields, execute any SQL statement, manage keys in fields, and export data in various formats.

 

 Access to PhpMyAdmin

 

-cPanel:

 

To start you must log in to cPanel.

 

Within the “Databases” category, click on the “phpMyAdmin” icon

 

Common Errors (cPanel):

 

By default, WHM registered owners cannot access a database through a cPanel phpMyAdmin dependent. You will receive this error:

 

"This function is not available while connecting with root override. You are logged in with root or dealer password. Please login with user account password"

 

To resolve this, you will have to log out from the root, and log into the individual cPanel in order to access a database through phpMyAdmin.

 

When trying to enter your phpMyAdmin (cPanel> MySQL> phpMyAdmin) you may come across these errors:

 

 a) # 2002 - Server is not responding (or local MySQL server socket is not configured correctly)

 

In this case, please contact us so we can restart MySQL.

 

b) Tables are missing; database not found.

 

Make sure that the target database has tables. Tables produced manually with the MySQL Databases section of the cPanel.

 

If you are trying to import information into a database follow this instruction:

 

If the database has tables in it, but they are not visible, just refresh the screen. Alternatively, click on the Structure tab at the top

When you see your table name, click on the first icon under Actions (Browse).

 

c) phpMyAdmin shows a login screen

 

If clicking the phpMyAdmin button on your cPanel takes you to a phpMyAdmin login page, this means that your MySQL and cPanel passwords have been synced. You can solve this yourself, simply by changing your cPanel password.

  • Email, SSL
  • 0 Los Usuarios han Encontrado Esto Útil
¿Fue útil la respuesta?

Related Articles

What is an inode and how is it limited in Neolo hosting?

 What is an inode?An inode is a data structure on a linux / Unix file system. An inode stores...

Website suspended for excessive resource usage

Resources on a server are limited and therefore the CPU and RAM disk usage are monitored for...

How to fix: You Have Reached a Domain that is Pending ICANN Verification

If your website is redirected to a site owned by ICANN (the Internet Corporation for Assigned...

How to create a new email account?

To create a new email account follow these steps: Log into your cPanel account Click on Email...

How to activate the free HTTPS SSL add-on with Cloudflare?

  Important: Using a free certificate like Cloudflare's or Let's Encrypt, there are certain...