MySQL is one of the most widespread database management systems on the market. A database is a group of cells with info that are arranged in tables and the management system is the software which links the info to a script application. As an illustration, a forum stores all posts, usernames, avatars and so on inside a database and each time a website visitor opens a given thread, the forum script connects to the database and “calls” the content that has to be displayed on a specific page. MySQL is very popular because of its terrific functionality, simplicity and the fact that it can operate with a lot of popular scripting languages like PHP, Python, Perl, etcetera. All dynamic websites that are built with a script-driven app need some form of database and many of the most widely used ones such as Joomla™, Moodle, Mambo and WordPress work with MySQL.
MySQL 5 Databases in Shared Hosting
The in-house built Hepsia Control Panel offered with our shared hosting will enable you to take care of all your MySQL databases easily. It takes only a few mouse 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 web site, for example. You will be able to modify the password, remove a database or permit remote access to it just as fast. For the latter option you may choose the IP addresses that'll be able to connect to the database remotely in order to ensure that unauthorized people will not be able to access your information. If you'd like to view the database content or edit any cell or table via the Control Panel, you should use phpMyAdmin, an excellent web-based interface. Using any of our script-driven applications shall also be easy as our script installer will set up a database for the script you have chosen automatically.
MySQL 5 Databases in Semi-dedicated Servers
All our semi-dedicated servers offer MySQL 5 support and the administration of your databases will be really easy. With just a couple of mouse clicks you will be able to set up a whole new database, remove an existing one or alter its password. The Hepsia web hosting Control Panel shall also provide you with access to far more advanced features such as a one-click backup and remote access. For the latter option, you can add only the IP address of your personal computer to make sure that no one else will be able to access your information. In this way, you can manage the content of any database inside the account via any application on your personal computer. If you want to do this online, you may use the phpMyAdmin tool, that is available through Hepsia. You shall also be able to view hourly and day-to-day MySQL stats, that will show you how your sites perform and if any of them needs to be optimized.