phpMyAdmin is a powerful PHP-based software tool used to handle MySQL databases through a web interface. You can use it to run MySQL commands, create, modify and erase cells, rows and tables or control users with separate levels of access to the database in question. Every one of these tasks can be done from any device given that you have an Internet browser and access to the website hosting account where the database is. With phpMyAdmin, you could also export or import a whole database, which is a very useful function if you would like to migrate a web site 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 would like to do - move the data from one internet hosting account to another, preview a whole database in a spreadsheet application for instance Microsoft Excel, and so forth.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of each shared hosting we provide and it is accessible through our custom-made Hepsia Control Panel. A small phpMyAdmin icon will be displayed on the right side of any database that you create inside the MySQL Databases section of the Control Panel and by clicking on the icon for the database that you want to access, you shall be logged into the app immediately in a new tab of your browser. Then you can do everything you would like - export the entire or part of the data, import a database, run SQL queries, search and change terms. If you do not want to go through the Control Panel, you will also be able to sign in through a direct phpMyAdmin login page, but you need to know the database username and password. The last function is helpful if you have to provide access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
When you host any script-driven site inside a semi-dedicated server account from our company, you will be able to handle the website database manually effortlessly because you can sign in to phpMyAdmin straight from your web hosting Control Panel. Any MySQL database which you set up shall be listed in the Databases section of your account and it will have a phpMyAdmin icon on its right side. Accessing the tool for a certain database is as easy as clicking on that icon and our system shall open a new tab in your web browser and it will log you in automatically, to enable you to export/import or change any content that you'd like. We also provide the option to sign in directly to phpMyAdmin without using your CP. In cases like this, the login is manual and requires a username and a password. This function permits you to provide access to a specific database to other individuals without giving them access to your website hosting account.