phpMyAdmin is a highly efficient PHP-based software tool employed to manage MySQL databases through a web interface. You may use it to run MySQL commands, create, edit and erase cells, rows and tables or manage users with various levels of access to the database in question. Every one of these tasks can easily be done from any device given that you have a web browser and access to the website hosting account where the database is. With phpMyAdmin, you can also export or import an entire database, which is a very beneficial feature if you would like to migrate a web site from one web hosting provider to another. Several different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, based upon what you need to do - move the content from one internet hosting account to another, preview a whole database in a spreadsheet application for example Microsoft Excel, and so on.
phpMyAdmin in Shared Hosting
phpMyAdmin is a part of every single shared plan
which we provide and it is accessible through our custom-built Hepsia CP. A tiny phpMyAdmin icon will be shown on the right side of each database that you create in the MySQL Databases section of the Control Panel and by clicking on the icon for the database that you want to access, you shall be logged into the app automatically in a new tab of your browser. Then you can do everything you'd like - export the whole or a part of the data, import a database, run SQL queries, search and replace terms. If you do not want to go through the Control Panel, you shall also be able to log in via a direct phpMyAdmin login page, but you need to know the database account information. The last feature is beneficial 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 through our company, you'll be able to access phpMyAdmin to handle any MySQL database that you set up in your account through the Hepsia hosting Control Panel. A new tab shall open within your Internet browser as soon as you click on the phpMyAdmin icon for a particular database and you'll be logged into the innovative tool automatically, so you'll not need to type the database username or password. If you want to provide access to another person such as a website designer, for example, you can give them the database login credentials and they shall be able to log in by using a direct link to phpMyAdmin, so they shall never need access to your whole hosting account. This option will allow you to keep your files and emails safe at all times.