Find out what phpMyAdmin is, exactly what it’s useful for and why you will need it for your web sites.
phpMyAdmin is a highly efficient PHP-based tool used to handle MySQL databases using a web interface. You could employ it to run MySQL commands, set up, change and remove cells, rows and tables or manage users with separate levels of access to the database in question. These tasks may be performed from any device given that you have a browser and access to the hosting account where the database is. With phpMyAdmin, you can also export or import a whole database, which is a very useful function if you'd like to migrate an Internet site from one web hosting provider to another. A number of different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, depending on what you'd like to do - move the data from one internet hosting account to another, preview an entire database in a spreadsheet application like Microsoft Excel, and so forth.
phpMyAdmin in Cloud Hosting
phpMyAdmin is a part of each cloud plan which we offer and it's accessible from our custom-made Hepsia CP. A tiny phpMyAdmin icon shall be shown on the right side of every database that you set up in the MySQL Databases section of the CP and by clicking on the icon for the database that you want to access, you'll be logged into the application instantly in a new tab of your 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 replace terms. If you do not want to go through the CP, you'll also be able to log in through a direct phpMyAdmin login page, but you must know the database username and password. The last function is beneficial if you have to grant access to a database to a third-party.