Find out what phpMyAdmin is, what it’s utilized for and the reason why you will need it for your websites.
phpMyAdmin is a powerful PHP-based tool employed to handle MySQL databases via a web interface. You can use it to run MySQL commands, set up, edit and erase cells, rows and tables or control users with separate levels of access to the database in question. Every one of these tasks could be done from any device as long as you have an Internet browser and access to the Internet hosting account where the database is. With phpMyAdmin, you can also export or import a whole database, which is an extremely helpful feature if you'd like to migrate a website from one hosting provider to another. Many different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, based upon what you want to do - move the content from one internet hosting account to another, preview a whole database in a spreadsheet app like Microsoft Excel, and so on.
phpMyAdmin in Shared Website Hosting
phpMyAdmin is provided as part of our shared website hosting plans
and you'll be able to access it whenever you want through your Hepsia CP. All databases which you set up inside the account shall be listed in alphabetical order inside the MySQL Databases section of the Control Panel and all it shall take to log in to any of them shall be to click on the little phpMyAdmin icon, which will be on the right side of every database. You will not have to type in any information, since you will be logged in automatically in a new Internet browser tab. If you prefer to log in by hand and not using the CP, you will be able to do so via our direct phpMyAdmin login page where you shall have to type in the database account information. This option is useful if you need to grant access to a specific database to some third party, such as a web designer.
phpMyAdmin in Semi-dedicated Servers
If you host your script-driven website in a semi-dedicated server
account from our company, you will be able to administer the site database manually with ease because you can sign in to phpMyAdmin straight from your website hosting Control Panel. Any MySQL database that you create shall be listed in the Databases section of your account and it'll have a phpMyAdmin icon on its right side. Accessing the tool for a particular database is as basic as clicking on that icon and our system will open a new tab inside your browser and it shall log you in automatically, to enable you to export/import or change any content you want. We also provide the option to sign in directly to phpMyAdmin without employing your CP. In cases like this, the login is manual and requires a username and a password. This function makes it possible for you to grant access to a certain database to other people without giving them access to your web hosting account.