Discover more about what phpMyAdmin is and how to use it as a management tool for your MySQL databases.
phpMyAdmin is a feature-rich tool developed in PHP, which shall present you with complete control of a MySQL database. You can do virtually anything - create fields, rows and tables, remove them or change their data, export or import a whole database or just a certain part of it, and execute MySQL commands. The tool is vital in case you need to switch web hosting providers, since you can easily generate a full backup of a database in different formats (SQL, CSV, XML). You will end up with a single file which contains the entire content of the database, so you may download it from the current provider, upload it to the hosting server of the new one and import it using the same tool on their end. Your website will look exactly the same, simply because all script apps store their data within a database. With phpMyAdmin you can also quickly search and replace content material of your choosing across the whole internet site - a word, a phrase or a link, for example.
phpMyAdmin in Shared Website Hosting
You'll be able to employ phpMyAdmin to access any database which you set up inside a shared website hosting
account bought through our company since we offer the tool by default with all our hosting plans. After you sign in to your Hepsia Internet hosting Control Panel and set up a new database in the MySQL Databases section, a small phpMyAdmin icon shall appear on its right-hand side. All it takes to log in immediately is to click on that icon and the tool shall open in a new web browser tab, so you can handle the database content. That is also the way to import a database when you are moving your Internet site from another service provider to our sophisticated cloud hosting platform. A different way to log in to a database is if you use our direct phpMyAdmin login URL, but you need to know the DB username and password. This option will permit you to grant access to any database to other people, without granting them access to the whole Internet hosting account.
phpMyAdmin in Semi-dedicated Servers
phpMyAdmin is one of the software tools that come with all our semi-dedicated servers
. You may log into it and control your MySQL databases if you click on the phpMyAdmin icon situated on the right side of every database which you have created through your Hepsia hosting CP. You won't have to do anything else, because our system will log you in automatically and you could proceed with the tasks you have to do - import a database file from another provider, change some content, and so on. You can easily access a database by using the direct phpMyAdmin login page too, but in this case you'll have to enter the correct details. You can use this option if you hire a web designer, as they can work on your website without accessing your hosting CP. In this way, all files and email messages which you have in the account will be protected.