Discover more about what phpMyAdmin is and the way to take advantage of it as an administrative instrument for all your MySQL databases.
phpMyAdmin is a powerful PHP-based software tool used to manage MySQL databases using a web interface. You can use it to run MySQL commands, set up, change and erase cells, rows and tables or manage users with different levels of access to the database in question. Each one of these tasks could be carried out from any device provided that you have an Internet browser and access to the Internet hosting account where the database is. With phpMyAdmin, you may also export or import a whole database, which is an extremely helpful feature if you want to migrate a web site from one hosting provider to another. Many different file formats are supported for the so-called dump file - CSV, SQL, XML and PDF, depending on what you need to do - move the data from one internet hosting account to another, preview a whole database in a spreadsheet app for example Microsoft Excel, and so on.
phpMyAdmin in Shared Web Hosting
phpMyAdmin is part of every Linux shared web hosting
that we offer and it's accessible from our in-house made Hepsia CP. A tiny phpMyAdmin icon will be displayed on the right side of each database that you create inside the MySQL Databases section of the Control Panel and by clicking on the icon for the database which you want to access, you shall be logged into the application immediately in a new tab of your Internet browser. Then you can do everything you'd like - export the entire or part of the data, import a database, run SQL queries, search and replace terms. If you don't want to go through the Control Panel, you'll also be able to sign in via a direct phpMyAdmin login page, but you must know the database account information. The last feature is handy if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Hosting
phpMyAdmin is one of the software tools that come with our Linux semi-dedicated hosting
. You may log into it and control your MySQL databases if you click on the phpMyAdmin icon located on the right side of each and every database that you have created using your Hepsia website hosting Control Panel. You will not have to do anything else, since our system will log you in automatically and you can proceed with the tasks you need to do - import a database file from another hosting service provider, change some content, and so on. You may access a database by using our direct phpMyAdmin login page too, but in cases like this you'll have to input the correct account information. You can use this option if you hire a web designer, as they can work on your site without accessing your web hosting Control Panel. Thus, all files and e-mails which you have inside the account will be protected.