phpMyAdmin is a feature-rich tool written in PHP, which will give you total control over a MySQL database. You may do virtually everything - create fields, rows and tables, erase them or change their data, export or import a whole database or just a particular part of it, and execute MySQL commands. The tool is very important in case you want to switch web hosting providers, as you could very easily generate a full backup of a database in different formats (SQL, CSV, XML). You shall end up with just one file that contains the whole content of the database, so you could 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 internet site shall look exactly the same, for the reason that all script applications store their data inside a database. With phpMyAdmin you can also effortlessly search and replace information of your choosing across the whole web site - a word, an expression or a link, for instance.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of each and every Linux shared hosting package which we offer and it is accessible via our tailor-made Hepsia Control Panel. A small phpMyAdmin icon shall be displayed on the right side of any database that you create inside the MySQL Databases section of the CP and by clicking on the icon for the database which you want to access, you will be logged into the app automatically in a new tab of your Internet browser. Then you can do everything you would like - export the entire or 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 shall also be able to log in via a direct phpMyAdmin login page, but you must know the database username and password. The last function is handy if you have to provide access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
We supply phpMyAdmin with every semi-dedicated server account as our packages support MySQL-driven Internet sites. The tool is integrated inside our in-house built Hepsia Internet hosting Control Panel and if you would like to change any database, you just have to go to the MySQL section and click on the phpMyAdmin icon for a specific database. You will not need any login credentials due to the fact that you'll be logged in automatically. If you don't want to employ your Control Panel or you need to provide access to any database to another person for some reason, you will also have an alternative option - to visit our phpMyAdmin direct login webpage where our system will require the database details. If you hire a website design company, for example, you can take advantage of this option to enable them to work on your site without giving them access to any files, e-mails or some other databases inside the account.