What's phpMyAdmin? What is its purpose? Why will your web sites require it?
phpMyAdmin is a powerful PHP-based software tool employed to handle MySQL databases through a web interface. You could employ it to run MySQL commands, set up, edit and erase cells, rows and tables or handle users with different levels of access to the database in question. Every one of these tasks can be completed from any device provided that you have an Internet browser and access to the Internet hosting account where the database is. With phpMyAdmin, you may also export or import a whole database, which is a very beneficial function if you want 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 on what you want to do - move the data from one web hosting account to another, preview an entire database in a spreadsheet app for example Microsoft Excel, and so on.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of each and every Linux shared hosting
which we offer and it is accessible via our in-house built Hepsia Control Panel. A small phpMyAdmin icon shall be shown on the right side of any database which you set up 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 application immediately in a new tab of your Internet browser. Then you can do everything you'd like - export the entire or a part of the data, import a database, run SQL queries, search and change terms. If you don't want to go through the Control Panel, you will also be able to log in via a direct phpMyAdmin login page, but you must know the database account information. The last function is handy if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
If you host any script-driven Internet site inside a semi-dedicated server
account from our company, you will be able to control the website database manually effortlessly since you can sign in to phpMyAdmin directly from your website hosting CP. Any MySQL database you set up will be listed in the Databases section of your account and it shall have a phpMyAdmin icon on its right side. Accessing the tool for a specific database is as easy as clicking on that icon and our system shall open a new tab in your Internet browser and it will log you in automatically, to permit you to export/import or change any content that you want. We also provide 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 will enable you to provide access to a particular database to other individuals without giving them access to your website hosting account.