If you use a script-driven app for your website, any data which both you and the website users create shall be stored within a database - a collection of info, which is arranged in cells and tables for simplier and easier reading and writing. The latter is accomplished through special software referred to as database management system and one of the most widely used ones worldwide is MySQL. A wide range of script apps are designed to work with MySQL since it is simple to use, it works very well on a web server and it's also universal as it can function with well-known web programming languages (Java, Perl, Python, PHP) and on numerous server Operating Systems (UNIX, Linux, Windows). There are hundreds of scripts that use MySQL, including very popular ones for instance WordPress, Joomla™ and Moodle.
MySQL 5 Databases in Shared Website Hosting
The in-house built Hepsia Control Panel included with our Linux shared website hosting packages allows you to manage all your MySQL databases without difficulty. It requires just a few clicks to set up a new database and with one more click you could back it up if you would like to have a copy before you update your website, for example. You will be able to modify the password, remove a database or permit remote access to it just as easily. For the latter option you may pick the IP addresses that will be able to connect to the database remotely in order to ensure that unauthorized people won't be able to access your info. If you would like to see the database content or change any cell or table using the CP, you should use phpMyAdmin, an effective web-based interface. Using any one of our script-driven applications shall also be super easy as our script installer will create a database for the script you have selected automatically.
MySQL 5 Databases in Semi-dedicated Hosting
All of our Linux semi-dedicated hosting packages come with MySQL 5 support and the administration of your databases will be very easy. With only a couple of clicks you’re able to create a new database, erase an existing one or alter its password. The Hepsia website hosting CP shall also provide you with access to more advanced features such as a one-click backup and remote accessibility. For the latter option, you could include only the IP address of your computer to ensure that nobody else will be able to access your data. Thus, you can handle the content of any database in the account using any app on your PC. If you want to do this online, you should use the phpMyAdmin tool, that is available through Hepsia. You will also be able to observe 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.