All script applications such as forums or online stores keep their data in a database - a collection of cells and tables which contains all of the site information including items, prices, comments, and many others. Every time you open a specific page, the script connects to the database and retrieves the necessary data, then displays it. The mid-level software that connects the script and the database is known as a database management system and among the most widely used ones is MySQL. The latter is frequently used as it operates on a variety of platforms (Windows, UNIX, Linux) and with a range of scripting languages (PHP, Perl, Python, Java), not mentioning its excellent functionality even with large databases. Many widely used platforms including WordPress or Joomla use MySQL databases to store their content.
MySQL 5 Databases in Cloud Hosting
The in-house built Hepsia Control Panel that comes with our cloud hosting plans allows you to take care of all your MySQL databases easily. It takes just a couple of mouse clicks to create a brand new database and with one more click you may back it up if you'd like to have a copy before you update your web site, for instance. You'll be able to change the password, remove a database or permit remote access to it just as easily. For the latter option you can pick the IP addresses that'll be able to connect to the database remotely in order to ensure that unauthorized people won't be able to access your data. If you want to see the database content or modify any cell or table via the CP, you can use phpMyAdmin, an efficient web-based interface. Using any one of our script-driven apps will also be easy as our script installer will create a database for the script that you have selected automatically.
MySQL 5 Databases in Semi-dedicated Servers
All of our semi-dedicated hosting plans come with MySQL 5 support and the administration of your databases will be quite simple. With just a couple of mouse clicks you will be able to create a whole new database, remove an existing one or alter its password. The Hepsia web hosting CP will also offer you access to more advanced functions like a one-click backup and remote accessibility. For the latter option, you can add only the IP address of your personal computer to be sure that no one else is going to be able to access your info. That way, you can manage the content of any database in the account through any app on your personal computer. If you want to do this online, you can use the phpMyAdmin tool, that's available through Hepsia. You will also be able to view hourly and day-to-day MySQL stats, that will show you how your sites perform and if any one of them has to be optimized.