Find out what phpMyAdmin is, just what it’s employed for and why you will need it for your websites.
phpMyAdmin is a feature-rich tool coded in PHP, which shall provide you with total control of a MySQL database. You could do absolutely everything - create fields, rows and tables, erase them or modify their data, export or import a whole database or only a certain part of it, and execute MySQL commands. The tool is essential if you want to switch web hosting companies, as you may very easily generate a full backup of a database in a variety of formats (SQL, CSV, XML). You shall end up with one file containing the entire content of the database, so you can download it from the present provider, upload it to the server of the new one and import it through the same tool on their end. Your site shall look exactly the same, because all script apps store their content inside a database. With phpMyAdmin you can also effortlessly search and replace content of your preference across the entire website - a word, a phrase or a link, for example.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of each and every Linux shared hosting package
which we provide and it's accessible through our custom-made Hepsia CP. A little phpMyAdmin icon will be shown on the right side of any database that 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 will be logged into the app automatically in a new tab of your Internet browser. Then you can do anything you'd like - export the entire or a part of the data, import a database, run SQL queries, search and change terms. If you do not want to use the CP, you shall also be able to log in using a direct phpMyAdmin login page, but you should know the database username and password. The last feature is helpful if you have to grant access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
We supply phpMyAdmin with each and every semi-dedicated server
account due to the fact that our plans support MySQL-driven sites. The tool is included inside our in-house built Hepsia hosting CP and if you'd like to edit any database, you just have to go to the MySQL section and click on the phpMyAdmin icon for a certain database. You won't need any login credentials as you will be logged in automatically. If you do not want to employ your CP or you would like to grant access to any database to another person for whatever reason, you'll also have an alternative option - to go to our phpMyAdmin direct login page in which our system shall require the database details. If you hire a web designer, for example, you can use that option to permit them to work on your site without granting them access to any files, emails or other databases in the account.