What's phpMyAdmin? What is its role? Why will your websites need it?
phpMyAdmin is a feature-rich tool written in PHP, which shall offer you full control over a MySQL database. You may do virtually anything - create fields, rows and tables, erase them or alter their data, export or import a whole database or only a specific part of it, and execute MySQL commands. The tool is very important if you would like to switch web hosting providers, because you could very easily create a full backup of a database in several formats (SQL, CSV, XML). You'll end up with one file that contains the whole content of the database, so you may download it from the current provider, upload it to the hosting server of the new one and import it through the same tool on their end. Your site will look exactly the same, due to the fact that all script applications store their content in a database. With phpMyAdmin you can also conveniently search and replace content of your choice across the whole website - a word, an expression or a link, for example.
phpMyAdmin in Hosting
phpMyAdmin is part of every single Linux hosting which we provide and it is accessible through our in-house built Hepsia CP. A tiny phpMyAdmin icon will be shown on the right side of each database which you set up inside the MySQL Databases section of the CP and by clicking on the icon for the database you want to access, you shall be logged into the application automatically in a new tab of your web browser. Then you can do anything you'd like - export the entire or part of the content, import a database, run SQL queries, search and change terms. If you don't want to use the CP, you shall also be able to log 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 give access to a database to a third-party.