phpMyAdmin is a highly efficient PHP-based tool which is used to manage MySQL databases via a web interface. You may employ it to run MySQL commands, set up, modify and delete cells, rows and tables or handle users with separate levels of access to the database in question. Each one of these tasks could be completed from any device given that you have a web browser and access to the hosting account where the database is. With phpMyAdmin, you may also export or import a whole database, which is a very beneficial feature if you'd like to migrate an Internet 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 need to do - move the content from one hosting account to another, preview an entire database in a spreadsheet app for instance Microsoft Excel, etc.
phpMyAdmin in Hosting
phpMyAdmin is a part of every single hosting package that we offer and it's accessible via our custom-built 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 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 a part of the data, import a database, run SQL queries, search and change terms. If you don't want to employ the Control Panel, you shall also be able to log in through a direct phpMyAdmin login page, but you must know the database username and password. The last feature is helpful if you have to provide access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
If you host a script-driven Internet site inside a semi-dedicated server account from our company, you will be able to administer the website database manually without difficulty simply because you can log in to phpMyAdmin directly from your web hosting Control Panel. Any MySQL database which you create shall be listed in the Databases section of your account and it'll have a phpMyAdmin icon on its right side. Accessing the tool for a particular database is as simple as clicking on that icon and our system will open a new tab inside your web browser and it will log you in automatically, to enable you to export/import or change any content you want. We also offer the option to sign in straight to phpMyAdmin without using your Control Panel. In this case, the login is manual and requires a username and a password. This feature makes it possible for you to give access to a certain database to other individuals without giving them access to your hosting account.