Find out what phpMyAdmin is, what it’s used for and the reason why you will need it for your web sites.
phpMyAdmin is a feature-rich tool coded in PHP, which shall give you 100 % control of a MySQL database. You can do absolutely anything - create fields, rows and tables, delete them or alter their data, export or import a whole database or just a specific part of it, and execute MySQL commands. The tool is very important if you want to switch web hosting companies, due to the fact that you may easily create a full backup of a database in several formats (SQL, CSV, XML). You'll end up with just one file containing the whole content of the database, so you could download it from the current provider, upload it to the hosting server of the new one and import it through the same tool on their end. Your internet site shall look exactly the same, because all script applications store their data in a database. With phpMyAdmin you can also conveniently search and replace content material of your choice across the whole website - a word, an expression or a link, for instance.
phpMyAdmin in Web Hosting
phpMyAdmin is a part of every single web hosting plan
we offer and it's accessible from our in-house built Hepsia Control Panel. A little phpMyAdmin icon shall be shown on the right side of every database you set up in 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 browser. Then you can do anything you would like - export the entire or part of the content, import a database, run SQL queries, search and replace terms. If you do not want to go through the Control Panel, you'll also be able to sign in via a direct phpMyAdmin login page, but you should know the database username and password. The last function is beneficial if you have to give access to a database to a third-party.
phpMyAdmin in Semi-dedicated Servers
If you have a semi-dedicated server
plan from our company, you shall be able to access phpMyAdmin to handle any MySQL database that you create inside your account from the Hepsia hosting Control Panel. A new tab shall open within your web browser the moment you click on the phpMyAdmin icon for a particular database and you'll be logged into the advanced tool automatically, so you'll not need to enter the database username or password. If you would like to give access to another person like a web developer, for example, you could give them the database login details and they will be able to log in using a direct link to phpMyAdmin, so they shall never need access to your whole web hosting account. This option will allow you to keep your files and emails safe at all times.