phpMyAdmin is a powerful PHP-based tool used to control MySQL databases via a web interface. You could use it to run MySQL commands, create, change and delete cells, rows and tables or control users with various levels of access to the database in question. Each one of these tasks can easily be performed from any device provided that you have a web browser and access to the website hosting account in which the database is. With phpMyAdmin, you could also export or import an entire database, which is a very helpful function if you'd like to migrate a website from one hosting provider to another. Several different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, dependant upon what you would like to do - move the content from one hosting account to another, preview an entire database in a spreadsheet application for instance Microsoft Excel, and so on.
phpMyAdmin in Shared Hosting
phpMyAdmin is part of every Linux shared hosting package we provide and it's accessible from our custom-built Hepsia CP. A tiny phpMyAdmin icon shall be displayed on the right side of any database which you set up in the MySQL Databases section of the Control Panel and by clicking on the icon for the database which you want to access, you will be logged into the app instantly in a new tab of your Internet browser. Then you can do anything you would like - export the entire or part of the content, import a database, run SQL queries, search and replace terms. If you don't want to go through the Control Panel, you'll also be able to log in via a direct phpMyAdmin login page, but you need to know the database username and password. The last function is useful if you have to grant access to a database to a third-party.