All script applications such as forums or virtual shops keep their information inside a database - a collection of cells and tables that contains all of the site info like items, prices, comments, and many others. Each time you open a particular page, the script connects to the database and retrieves the necessary information, then displays it. The intermediary software that connects the script and the database is called a database management system and one of the most well-known ones is MySQL. The latter is frequently used because it works on a variety of platforms (UNIX, Linux, Windows) and with a number of scripting languages (Java, Perl, Python, PHP), not mentioning its great efficiency even with big databases. Lots of widely used platforms like WordPress or Joomla use MySQL databases to save their content.
MySQL 5 Databases in Shared Hosting
The in-house built Hepsia Control Panel included with our Linux shared hosting will allow you to take care of all your MySQL databases with ease. It requires only a few mouse clicks to create a brand new database and with just one more click you can back it up if you want to have a copy before you update your Internet site, for example. You will be able to modify the password, delete a database or permit remote access to it just as easily. For the latter option you can opt for the IP addresses that'll be able to connect to the database remotely so as to ensure that unauthorized people won't be able to access your information. If you'd like to see the database content or edit any cell or table from the Control Panel, you should use phpMyAdmin, an efficient web-based interface. Using any of our script-driven applications will also be easy as our script installer will set up a database for the script which you have picked automatically.
MySQL 5 Databases in Semi-dedicated Hosting
All of our semi-dedicated packages offer MySQL 5 support and the administration of your databases will be easy. With just a couple of mouse clicks you'll be able to set up a completely new database, erase an existing one or modify its password. The Hepsia website hosting Control Panel will also give you access to more advanced features like a one-click backup and remote access. For the latter option, you can add only the IP address of your computer to ensure that no one else is going to be able to access your data. Thus, you can manage the content of any database inside the account using any app on your PC. If you want to do this online, you can use the phpMyAdmin tool, that is available through Hepsia. You'll also be able to view hourly and day-to-day MySQL statistics, that will show you how your websites perform and if any of them should be optimized.