Find out more about what phpMyAdmin is and how to take advantage of it as a management instrument for your MySQL databases.
phpMyAdmin is an efficient PHP-based software tool which is used to handle MySQL databases using a web interface. You can employ it to run MySQL commands, set up, edit and erase cells, rows and tables or handle users with different levels of access to the database in question. Every single one of these tasks may be performed from any device provided that you have an Internet browser and access to the Internet hosting account in which the database is. With phpMyAdmin, you could also export or import a whole database, which is a very beneficial feature if you want to migrate an Internet site from one web hosting provider to another. A number of different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, based on what you want to do - move the data from one web hosting account to another, preview a whole database in a spreadsheet app such as Microsoft Excel, and so forth.
phpMyAdmin in Website Hosting
phpMyAdmin is part of each and every website hosting plan
which we offer and it is accessible via our custom-made Hepsia CP. A little phpMyAdmin icon will be shown on the right side of each database that you create inside the MySQL Databases section of the Control Panel and by clicking on the icon for the database you want to access, you will be logged into the app immediately in a new tab of your browser. Then you can do everything you'd like - export the whole or a part of the content, import a database, run SQL queries, search and change terms. If you don't want to go through the CP, you'll also be able to sign in through a direct phpMyAdmin login page, but you need to know the database username and password. The last feature is useful if you have to grant access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
When you host your script-driven website in a semi-dedicated server
account from our company, you'll be able to manage the site database manually with ease because you can sign in to phpMyAdmin straight from your website hosting CP. Any MySQL database which you create shall be listed in the Databases section of your account and it will have a phpMyAdmin icon on its right side. Accessing the tool for a certain database is as easy as clicking on that icon and our system will open a new tab inside your web browser and it shall log you in automatically, to permit you to export/import or change any content that you'd like. We also provide the option to sign in directly to phpMyAdmin without going through your CP. In cases like this, the login is manual and requires a username and a password. This feature will permit you to grant access to a particular database to other individuals without giving them access to your website hosting account.