Learn more about what phpMyAdmin is and the best way to use it as a management tool for your MySQL databases.
phpMyAdmin is a feature-rich tool coded in PHP, which shall provide you with 100 % control over a MySQL database. You could do practically anything - set up fields, rows and tables, remove them or change their data, export or import a whole database or just a particular part of it, and execute MySQL commands. The tool is essential when you need to switch web hosting companies, simply because you may very easily create a full backup of a database in a variety of formats (SQL, CSV, XML). You will end up with a single file which contains the whole content of the database, so you can easily download it from the present provider, upload it to the web server of the new one and import it through the same tool on their end. Your internet site will look exactly the same, for the reason that all script applications store their content in a database. With phpMyAdmin you could also effortlessly search and replace information of your choosing across the whole internet site - a word, a phrase or a link, for example.
phpMyAdmin in Cloud Website Hosting
phpMyAdmin is part of each cloud website hosting
we provide and it's accessible through our in-house built Hepsia Control Panel. A small phpMyAdmin icon will be displayed on the right side of any database you set up inside the MySQL Databases section of the CP and by clicking on the icon for the database which you want to access, you shall be logged into the app instantly in a new tab of your 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 change terms. If you do not want to employ the CP, you shall also be able to sign in using a direct phpMyAdmin login page, but you ought to know the database username and password. The last feature is handy if you have to provide access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
If you host any script-driven website inside a semi-dedicated server
account from our company, you will be able to handle the site database manually without difficulty as you can sign in to phpMyAdmin directly from your website hosting CP. Any MySQL database that you create shall be listed in the Databases section of your account and it'll have a phpMyAdmin icon on its right side. Accessing the tool for a specific database is as basic as clicking on that icon and our system will open a new tab in your Internet browser and it will log you in automatically, so that you can export/import or modify any content you want. We also provide the option to sign in directly to phpMyAdmin without using your Control Panel. In this case, the login is manual and requires a username and a password. This function makes it possible for you to give access to a specific database to other people without giving them access to your hosting account.