phpMyAdmin is a highly efficient PHP-based tool employed to control MySQL databases through a web interface. You could use it to run MySQL commands, create, edit and erase cells, rows and tables or handle users with separate levels of access to the database in question. These tasks can be carried out from any device given that you have an Internet browser and access to the hosting account in which the database is. With phpMyAdmin, you can also export or import a whole database, which is an extremely helpful function if you'd like to migrate a web site from one web hosting provider to another. Many different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, depending on what you need to do - move the content from one hosting account to another, preview an entire database in a spreadsheet application such as Microsoft Excel, and so forth.
phpMyAdmin in Website Hosting
phpMyAdmin is a part of each and every Linux website hosting service that we offer and it's accessible via our custom Hepsia Control Panel. A small phpMyAdmin icon shall be displayed on the right side of any database which you create in the MySQL Databases section of the Control Panel and by clicking on the icon for the database you want to access, you'll be logged into the app automatically in a new tab of your Internet 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 replace terms. If you do not want to use the CP, you shall also be able to sign in via a direct phpMyAdmin login page, but you must know the database account information. The last function is useful 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'll be able to manage the website database manually effortlessly because you can log in to phpMyAdmin directly from your web hosting CP. Any MySQL database which you create will 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 specific database is as basic as clicking on that icon and our system shall open a new tab in your web browser and it will log you in automatically, so that you can export/import or change any content that you'd like. We also offer the option to sign in straight to phpMyAdmin without going through your CP. In cases like this, the login is manual and requires a username and a password. This feature will allow you to grant access to a certain database to other individuals without giving them access to your hosting account.