phpMyAdmin is a powerful PHP-based tool used to handle 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 separate levels of access to the database in question. All these tasks may be done from any device provided that you have a browser and access to the web hosting account in which the database is. With phpMyAdmin, you may also export or import a whole database, which is a very beneficial feature if you would like to migrate a website from one web hosting provider to another. Several different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, dependant upon what you need to do - move the data from one hosting account to another, preview a whole database in a spreadsheet app like Microsoft Excel, etc.
phpMyAdmin in Shared Website Hosting
phpMyAdmin is part of every single shared website hosting plan which we provide and it is accessible through our in-house built Hepsia Control Panel. A little phpMyAdmin icon will be shown on the right side of each database which you set up in 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 immediately in a new tab of your Internet 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 do not want to employ the Control Panel, you shall also be able to log in using a direct phpMyAdmin login page, but you should know the database username and password. The last function is handy if you have to provide 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 shall be able to access phpMyAdmin to control any MySQL database that you set up in your account through the Hepsia hosting Control Panel. A new tab will open in your web browser the moment you click on the phpMyAdmin icon for a specific database and you will be logged into the innovative tool automatically, so you will not need to input the database username or password. If you would like to grant access to another person like a web designer, for instance, you can give them the database login information and they will be able to log in from a direct link to phpMyAdmin, so they shall never need access to your entire hosting account. This option will allow you to keep your files and emails safe at all times.