Learn what phpMyAdmin is, precisely what it’s used for and the reasons why you will be needing it for your web sites.
phpMyAdmin is a feature-rich tool developed in PHP, which shall give you total control over a MySQL database. You can do literally everything - set up fields, rows and tables, remove them or change their data, export or import a whole database or just a certain part of it, and execute MySQL commands. The tool is vital when you need to switch web hosting providers, because you may very easily generate a full backup of a database in several formats (SQL, CSV, XML). You shall end up with a single file containing the whole content of the database, so you may download it from the present provider, upload it to the hosting server of the new one and import it via the same tool on their end. Your internet site shall look exactly the same, because all script applications store their data inside a database. With phpMyAdmin you may also easily search and replace content of your choosing across the whole web site - a word, a phrase or a link, for example.
phpMyAdmin in Website Hosting
phpMyAdmin is a part of every Linux website hosting plan
that we offer and it is accessible through our custom-made Hepsia CP. A little phpMyAdmin icon will be displayed on the right side of every database that you create in the MySQL Databases section of the Control Panel and by clicking on the icon for the database which you want to access, you'll be logged into the app immediately in a new tab of your Internet browser. Then you can do anything you would like - export the whole or a part of the content, import a database, run SQL queries, search and replace terms. If you do not want to use the CP, you'll 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 beneficial if you have to grant access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
When you have a semi-dedicated server
package through our company, you shall be able to access phpMyAdmin to manage any MySQL database you create in your account from the Hepsia hosting CP. A new tab shall open within your Internet browser the instant you click on the phpMyAdmin icon for a particular database and you will be logged into the advanced tool automatically, so you'll not have to type in the database username or password. If you would like to provide access to another person like a website designer, for instance, you could give them the database login information and they shall be able to log in via a direct link to phpMyAdmin, so they'll never need access to your entire web hosting account. This option will allow you to keep your files and emails safe at all times.