MySQL 5 Databases
Learn what relational databases are and if using MySQL databases can be beneficial for your websites and applications.
All script applications like forums or online shops store their data inside a database - a collection of cells and tables which contains all of the Internet site data such as items, prices, comments, and so forth. Whenever you open a particular page, the script connects to the database and retrieves the required information, then displays it. The mid-level software which connects the script and the database is known as a database management system and one of the most well-known ones is MySQL. The latter is frequently used simply because it can run on different platforms (UNIX, Linux, Windows) and with a variety of scripting languages (Java, PHP, Perl, Python), not mentioning its excellent efficiency even with big databases. Numerous popular platforms such as Joomla™ or WordPress 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 packages
will enable you to control all your MySQL databases without difficulty. It requires only a few mouse clicks to set up a completely new database and with only one more click you could back it up if you'd like to have a copy before you update your web site, for example. You'll be able to modify the password, delete a database or permit remote access to it just as fast. For the latter option you can choose the IP addresses that will be able to connect to the database remotely in order to make sure that unauthorized people will not be able to access your data. If you wish to view the database content or modify any cell or table via the Control Panel, you should use phpMyAdmin, a powerful web-based interface. Using any of our script-driven apps shall also be quite simple as our script installer will create a database for the script which you have selected automatically.
MySQL 5 Databases in Semi-dedicated Hosting
Each and every semi-dedicated server
that we provide comes with the latest version of MySQL pre-installed, so that you can run any script application you want. If you use our 1-click installer, you can create an application with a few clicks and our software tool will set up a whole new database automatically. If you prefer to install a script personally, you will be able to create a MySQL database easily, picking out its username and password. For your benefit, we've also added quick-access buttons to create a backup or allow remote access to each of your databases. More experienced users can easily sign in to the effective phpMyAdmin tool and edit certain cells or whole tables by hand through a web interface. Inside the Databases section of the Hepsia hosting CP you shall also find hourly and daily stats for each database which you have set up in the account.