Learn what phpMyAdmin is, exactly what it’s used for and the reasons why you will be needing it for your websites.
phpMyAdmin is a feature-rich tool written in PHP, which shall give you full control over a MySQL database. You could do virtually anything - set up fields, rows and tables, erase them or alter their content, export or import an entire database or just a certain part of it, and execute MySQL commands. The tool is irreplaceable in case you would like to switch web hosting providers, because you may effortlessly create a full backup of a database in a number of formats (SQL, CSV, XML). You shall end up with just one file containing the entire content of the database, so you could 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 site shall look exactly the same, for the reason that all script applications store their content within a database. With phpMyAdmin you may also quickly search and replace content material of your choice across the whole web site - a word, a phrase or a link, for example.
phpMyAdmin in Shared Hosting
phpMyAdmin is provided as an element of our shared hosting
and you will be able to access it whenever you want via your Hepsia Control Panel. All databases that you set up inside the account shall be listed in alphabetical order inside the MySQL Databases section of the CP and all it will take to log in to any of them shall be to click on the little phpMyAdmin icon, that'll be on the right side of each database. You won't need to input any information, as you'll be logged in automatically in a new browser tab. If you prefer to sign in by hand instead of going through the Control Panel, you'll be able to do that using our direct phpMyAdmin login page in which you shall have to input the database username and password. This option is helpful if you have to offer access to a specific database to some third party, for instance a web designer.
phpMyAdmin in Semi-dedicated Servers
If you have a semi-dedicated server
package from our company, you will be able to access phpMyAdmin to manage any MySQL database you create inside your account from the Hepsia hosting Control Panel. A new tab shall open within your web browser as soon as you click on the phpMyAdmin icon for a specific database and you will be logged into the state-of-the-art tool automatically, so you will not have to input the database username or password. If you want to provide access to another person like a website designer, for instance, you could give them the database login credentials and they will be able to log in from a direct link to phpMyAdmin, so they shall never need access to your whole internet hosting account. This option will allow you to keep your files and emails safe at all times.