MySQL is one of the most commonly used database control systems on the market. A database is a group of cells with info which are arranged in tables and the control system is the piece of software that links the info to a script app. As an illustration, a forum stores all usernames, avatars, posts and so on in a database and every time a site visitor opens a specific thread, the forum script connects to the database and “calls” the content which ought to be shown on a particular page. MySQL is very popular because of its great functionality, simplicity of use and the fact that it can work with numerous popular scripting languages including PHP, Python, Perl, etcetera. All dynamic websites that are built with a script-driven application require some form of database and a lot of the most widely used ones including Joomla, Moodle, Mambo and WordPress work with MySQL.
MySQL 5 Databases in Shared Website Hosting
The in-house built Hepsia CP included with our shared website hosting plans will enable you to manage all your MySQL databases easily. It requires only a few 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 web site, for example. You'll be able to modify the password, delete a database or permit remote access to it just as easily. For the latter option you may choose the IP addresses which will be able to connect to the database remotely in order to ensure that unauthorized people shall not be able to access your data. If you would like to see the database content or edit any cell or table from the CP, you should use phpMyAdmin, an excellent web-based interface. Using any of our script-driven apps 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 Servers
Our semi-dedicated hosting plans offer MySQL 5 support and the administration of your databases shall be quite simple. With just a couple of mouse clicks you'll be able to set up a new database, remove an existing one or modify its password. The Hepsia website hosting CP shall also give you access to more advanced features like a one-click backup and remote accessibility. For the latter option, you could include only the IP address of your personal computer to make sure that nobody else is going to be able to access your information. This way, you can manage the content of any database inside the account via any app on your personal computer. If you'd prefer to do this online, you could use the phpMyAdmin tool, that's available via Hepsia. You shall also be able to view hourly and day-to-day MySQL statistics, which will show you how your sites perform and if any of them needs to be optimized.