phpMyAdmin is a powerful PHP-based tool employed to handle MySQL databases through a web interface. You could use it to run MySQL commands, set up, change and erase cells, rows and tables or handle users with various levels of access to the database in question. Every one of these tasks can be performed from any device provided that you have a browser and access to the web hosting account where the database is. With phpMyAdmin, you could also export or import a whole database, which is an extremely helpful function if you would like to migrate a web site from one hosting provider to another. Several different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, depending on what you'd like to do - move the data from one hosting account to another, preview an entire database in a spreadsheet application for instance Microsoft Excel, and so forth.
phpMyAdmin in Hosting
phpMyAdmin is a part of every single Linux hosting plan which we provide and it's accessible through our custom-built Hepsia Control Panel. A little phpMyAdmin icon shall be shown on the right side of every 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 shall be logged into the application instantly in a new tab of your browser. Then you can do everything you would like - export the entire or a part of the data, import a database, run SQL queries, search and replace terms. If you do not want to employ the CP, you'll also be able to log in using a direct phpMyAdmin login page, but you ought to know the database account information. The last feature is helpful if you have to provide access to a database to a third-party.