Find out what phpMyAdmin is, precisely what it’s utilized for and why you will need it for your sites.
phpMyAdmin is a feature-rich tool coded in PHP, which will present you with 100 % control of a MySQL database. You could do virtually anything - create fields, rows and tables, remove them or alter their data, export or import a whole database or only a specific part of it, and execute MySQL commands. The tool is necessary in case you need to switch web hosting companies, due to the fact that you may easily create a full backup of a database in a variety of formats (SQL, CSV, XML). You will end up with only one file which contains the whole content of the database, so you may download it from the current provider, upload it to the server of the new one and import it via the same tool on their end. Your internet site shall look exactly the same, for the reason that all script apps store their content within a database. With phpMyAdmin you can also conveniently search and replace content of your choice across the whole web site - a word, an expression or a link, for example.
phpMyAdmin in Website Hosting
phpMyAdmin is part of every website hosting plan
we offer and it is accessible via our in-house made Hepsia CP. A tiny phpMyAdmin icon shall be displayed on the right side of each database 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'll be logged into the application instantly in a new tab of your web browser. Then you can do anything you would like - export the entire or a part of the data, import a database, run SQL queries, search and replace terms. If you don't want to employ the Control Panel, you shall also be able to log in through a direct phpMyAdmin login page, but you should know the database username and password. The last feature is useful if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
When you have a semi-dedicated server
package from our company, you will be able to access phpMyAdmin to control any MySQL database that you create inside your account from the Hepsia hosting CP. A new tab shall open within your browser the instant you click on the phpMyAdmin icon for a specific database and you'll be logged into the state-of-the-art tool automatically, so you'll not need to input the database username or password. If you would like to grant access to another person such as a web developer, for example, you can give them the database login credentials and they shall be able to log in via a direct link to phpMyAdmin, so they will never need access to your entire web hosting account. This option will allow you to keep your files and emails safe at all times.