phpMyAdmin is a highly efficient PHP-based tool employed to control MySQL databases through a web interface. You could employ it to run MySQL commands, set up, modify and erase cells, rows and tables or handle users with various levels of access to the database in question. Every one of these tasks could be carried out from any device provided that you have a web browser and access to the web hosting account where the database is. With phpMyAdmin, you may also export or import a whole database, which is a very helpful feature if you would like to migrate a web site from one hosting provider to another. A number of different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, based upon what you would like to do - move the content from one hosting account to another, preview a whole database in a spreadsheet app for instance Microsoft Excel, and so on.

phpMyAdmin in Web Hosting

phpMyAdmin is a part of every single web hosting plan we offer and it's accessible through our custom-made Hepsia Control Panel. A small phpMyAdmin icon shall be displayed on the right side of any database that you set up in the MySQL Databases section of the CP and by clicking on the icon for the database that you want to access, you shall be logged into the app automatically in a new tab of your web browser. Then you can do everything you'd like - export the entire or a part of the content, import a database, run SQL queries, search and replace terms. If you don't want to go through the CP, you'll also be able to log in via a direct phpMyAdmin login page, but you need to know the database account information. The last function is beneficial if you have to give access to a database to a third-party.