phpMyAdmin is an efficient PHP-based software tool which is used to handle MySQL databases through a web interface. You can use it to run MySQL commands, create, change and erase cells, rows and tables or manage users with separate levels of access to the database in question. All these tasks could be performed from any device provided that you have a web browser and access to the Internet hosting account in which the database is. With phpMyAdmin, you could also export or import an entire database, which is a very beneficial function if you want 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 on what you'd like to do - move the data from one internet hosting account to another, preview an entire database in a spreadsheet app for example Microsoft Excel, and so forth.
phpMyAdmin in Hosting
phpMyAdmin is a part of each Linux hosting that we provide and it's accessible from our custom-built Hepsia CP. A little phpMyAdmin icon shall be displayed on the right side of any database which you set up in the MySQL Databases section of the Control Panel and by clicking on the icon for the database you want to access, you'll be logged into the application instantly in a new tab of your Internet browser. Then you can do everything you would like - export the whole or a part of the data, import a database, run SQL queries, search and replace terms. If you don't want to use the CP, you will also be able to log in via a direct phpMyAdmin login page, but you should know the database username and password. The last function is helpful if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
If you have a semi-dedicated server package from our company, you'll be able to access phpMyAdmin to handle any MySQL database that you create in your account via the Hepsia hosting CP. A new tab shall open within your web browser the instant you click on the phpMyAdmin icon for a specific database and you'll be logged into the state-of-the-art tool automatically, so you will not need to enter the database username or password. If you would like to provide access to another person such as a web designer, for instance, you can give them the database login info and they will be able to log in via a direct link to phpMyAdmin, so they'll never need access to your entire web hosting account. This option will allow you to keep your files and emails safe at all times.