Discover more about what phpMyAdmin is and the way to make use of it as a management instrument for your MySQL databases.
phpMyAdmin is a feature-rich tool developed in PHP, that will provide you with 100 % control of a MySQL database. You may do virtually everything - create fields, rows and tables, remove them or modify their content, export or import a whole database or just a specific part of it, and execute MySQL commands. The tool is necessary in case you need to switch hosting companies, because you can conveniently generate a full backup of a database in a variety of formats (SQL, CSV, XML). You'll end up with only one file that contains the whole content of the database, so you can download it from the present provider, upload it to the hosting server of the new one and import it using the same tool on their end. Your website shall look exactly the same, because all script apps store their content within a database. With phpMyAdmin you can also effortlessly search and replace content of your choice across the entire web site - a word, a phrase or a link, for instance.
phpMyAdmin in Web Hosting
phpMyAdmin is a part of every Linux web hosting service
that we provide and it's accessible via our custom-built Hepsia Control Panel. A small phpMyAdmin icon shall be shown on the right side of every database which you set up in the MySQL Databases section of the CP and by clicking on the icon for the database you want to access, you will be logged into the app instantly in a new tab of your web browser. Then you can do anything you'd like - export the whole or a part of the data, import a database, run SQL queries, search and change terms. If you do not want to use the Control Panel, you will also be able to sign in using a direct phpMyAdmin login page, but you must know the database username and password. The last feature is handy if you have to grant access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
When you host a script-driven Internet site in a semi-dedicated server
account from our company, you will be able to handle the site database manually effortlessly because you can log in to phpMyAdmin straight from your website hosting Control Panel. Any MySQL database that you set up 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 particular database is as simple as clicking on that icon and our system shall open a new tab in your Internet browser and it will log you in automatically, to enable you to export/import or change any content you want. We also offer the option to sign in directly to phpMyAdmin without going through your Control Panel. In this case, the login is manual and requires a username and a password. This function enables you to give access to a certain database to other individuals without giving them access to your website hosting account.