Learn what phpMyAdmin is, exactly what it’s used for and the reasons why you will need it for your websites.
phpMyAdmin is a feature-rich tool written in PHP, which shall present you with full control over a MySQL database. You can do virtually everything - create fields, rows and tables, erase them or change their content, export or import a whole database or only a certain part of it, and execute MySQL commands. The tool is essential when you need to switch web hosting companies, simply because you could effortlessly generate a full backup of a database in several formats (SQL, CSV, XML). You shall end up with just one file that contains the whole content of the database, so you may download it from the present provider, upload it to the web server of the new one and import it through the same tool on their end. Your website shall look exactly the same, for the reason that all script apps store their data in a database. With phpMyAdmin you may also effortlessly search and replace information of your preference across the entire internet site - a word, an expression or a link, for instance.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of every single shared hosting service
which we offer and it is accessible via our custom-built Hepsia Control Panel. A tiny phpMyAdmin icon shall be shown on the right side of any database which you create inside the MySQL Databases section of the Control Panel and by clicking on the icon for the database which you want to access, you shall be logged into the application immediately in a new tab of your browser. Then you can do anything you would like - export the whole or part of the content, import a database, run SQL queries, search and modify terms. If you do not want to go through the CP, you shall also be able to sign in through a direct phpMyAdmin login page, but you should know the database account information. The last feature is helpful if you have to provide access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
phpMyAdmin is among the software instruments which come with our semi-dedicated service
. You can log into it and manage your MySQL databases if you click on the phpMyAdmin icon on the right side of each database which you have created through your Hepsia hosting CP. You will not need to do anything else, as our system shall log you in automatically and you can proceed with the tasks you should do - import a database file from another provider, change some content, and so forth. You could access a database by using our direct phpMyAdmin login page also, but in cases like this you'll have to input the correct details. You could use this option if you hire a website designer, as they can work on your site without accessing your website hosting Control Panel. Thus, all files and email messages you have inside the account will be protected.