phpMyAdmin is an efficient PHP-based tool employed to control MySQL databases using a web interface. You can use it to run MySQL commands, create, edit and remove cells, rows and tables or manage users with various levels of access to the database in question. All these tasks could be done from any device as long as you have a browser and access to the web hosting account in which the database is. With phpMyAdmin, you could also export or import an entire database, which is a very useful function if you want to migrate an Internet site from one hosting provider to another. A variety of file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, depending on what you would like to do - move the data from one web hosting account to another, preview an entire database in a spreadsheet application like Microsoft Excel, and so forth.
phpMyAdmin in Hosting
phpMyAdmin is a part of each hosting plan which we offer and it's accessible through our custom-made Hepsia Control Panel. A small phpMyAdmin icon will be shown on the right side of any database which you set up inside the MySQL Databases section of the Control Panel and by clicking on the icon for the database which you want to access, you will be logged into the app automatically 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 do not want to employ the CP, you will also be able to log in using a direct phpMyAdmin login page, but you need to know the database username and password. The last feature is helpful if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
We supply phpMyAdmin with each semi-dedicated server account due to the fact that our plans support MySQL-driven websites. The tool is integrated in our in-house built Hepsia Internet hosting CP and if you'd like to change any database, you just need to go to the MySQL section and click on the phpMyAdmin icon for a particular database. You will not need any login credentials because you shall be logged in automatically. If you do not want to go through your CP or you need to give access to any database to another individual for whatever reason, you'll have an alternative option - to navigate to our phpMyAdmin direct login page in which our system will require the database account information. If you hire a web developer, for example, you can use this particular option to allow them to work on your Internet site without granting them access to any files, email messages or any other databases in the account.