When you use a script-driven app for your website, any data which both you and the website users generate shall be stored in a database - a collection of data, that is arranged in cells and tables for simplier and easier reading and writing. The latter is carried out by using special software known as database management system and one of the most widely used ones world-wide is MySQL. A lot of script applications are created to work with MySQL as it is simple to use, it functions really well on a web server and it's universal as it can function with famous web programming languages (PHP, Java, Perl, Python) and on numerous hosting server OS (UNIX, Linux, Windows). There are hundreds of scripts which use MySQL, including quite popular ones for example Moodle, Joomla™ and WordPress.
MySQL 5 Databases in Web Hosting
The in-house built Hepsia CP that comes with our Linux web hosting packages will permit you to manage all your MySQL databases without difficulty. It takes just a few mouse clicks to set up a completely new database and with one more click you could back it up if you'd like to have a copy before you update your web site, for instance. You will be able to change the password, delete a database or enable remote access to it just as easily. For the latter option you could pick 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 information. If you'd like to view the database content or change any cell or table using the Control Panel, you can use phpMyAdmin, a powerful web-based interface. Using any of our script-driven apps will also be quite simple as our script installer will set up a database for the script which you have selected automatically.
MySQL 5 Databases in Semi-dedicated Hosting
All of our Linux semi-dedicated hosting packages offer MySQL 5 support and the administration of your databases will be quite simple. With just a couple of clicks you’re able to set up a new database, delete an existing one or modify its password. The Hepsia website hosting Control Panel will also offer you access to much more advanced functions including a one-click backup and remote access. For the latter option, you could include only the IP address of your computer to make sure that nobody else will be able to access your data. This way, you can handle the content of any database in the account using any app on your computer system. If you'd prefer to do this online, you may use the phpMyAdmin tool, that's available through Hepsia. You shall also be able to view hourly and daily MySQL stats, that will show you how your sites perform and if any of them has to be optimized.