Discover what phpMyAdmin is, what it’s employed for and why you will need it for your sites.
phpMyAdmin is a highly efficient PHP-based software tool employed to control MySQL databases through a web interface. You can employ it to run MySQL commands, create, change and remove cells, rows and tables or handle users with different levels of access to the database in question. Each one of these tasks may be completed from any device provided that you have a web browser and access to the Internet hosting account in which the database is. With phpMyAdmin, you could also export or import an entire database, which is a very useful feature if you would like to migrate a website from one hosting provider to another. Many different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, based upon what you'd like to do - move the content from one web hosting account to another, preview an entire database in a spreadsheet app for example Microsoft Excel, etc.
phpMyAdmin in Shared Website Hosting
phpMyAdmin is part of each and every shared website hosting plan we provide and it's accessible via our in-house made Hepsia CP. A small phpMyAdmin icon will be shown on the right side of any database which you set up inside 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 app automatically in a new tab of your web browser. Then you can do everything you'd like - export the whole or part of the data, import a database, run SQL queries, search and change terms. If you don't want to go through the CP, you will also be able to sign in via a direct phpMyAdmin login page, but you ought to know the database username and password. The last feature is useful if you have to grant access to a database to a third-party.