What is phpMyAdmin? What is its role? Why will your web sites require it?
phpMyAdmin is a feature-rich tool coded in PHP, which shall offer you complete control of a MySQL database. You can do literally everything - set up fields, rows and tables, delete them or alter their content, export or import an entire database or only a certain part of it, and execute MySQL commands. The tool is essential when you want to switch web hosting providers, due to the fact that you could very easily generate a full backup of a database in different formats (SQL, CSV, XML). You'll end up with a single file containing the whole content of the database, so you can download it from the current provider, upload it to the web server of the new one and import it via the same tool on their end. Your site shall look exactly the same, due to the fact that all script apps store their data within a database. With phpMyAdmin you can also conveniently search and replace content of your preference across the whole internet site - a word, an expression or a link, for instance.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of every single Linux shared hosting
that we offer and it is accessible through our custom Hepsia CP. A small phpMyAdmin icon shall be shown on the right side of every 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 application automatically in a new tab of your web browser. Then you can do everything you would like - export the entire or a part of the data, import a database, run SQL queries, search and modify terms. If you do not want to use the CP, you will also be able to sign in using a direct phpMyAdmin login page, but you need to know the database account information. The last feature is beneficial if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
If you host a script-driven Internet site in a semi-dedicated server
account from our company, you will be able to handle the website database manually without difficulty since you can log in to phpMyAdmin straight from your website hosting Control Panel. Any MySQL database that you create 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 specific database is as easy as clicking on that icon and our system will open a new tab inside your browser and it'll log you in automatically, to enable you to export/import or change any content that you'd like. We also offer the option to sign in straight to phpMyAdmin without using your CP. In such cases, the login is manual and requires a username and a password. This function will enable you to give access to a particular database to other people without giving them access to your Internet hosting account.