MySQL is one of the most widely used database management systems available. A database is a collection of cells with data that are organized in tables and the administration system is the software that links the information to a script app. For instance, a forum stores all usernames, avatars, posts etc in a database and every time a site visitor opens a particular thread, the forum script connects to the database and “calls” the content which should be shown on a certain page. MySQL is quite popular because of its great efficiency, convenience and the fact that it can operate with a lot of popular scripting languages like PHP, Python, Perl, etcetera. All dynamic websites that are designed with a script-driven application need some form of database and some of the most widely used ones including Joomla, Moodle, Mambo and WordPress use MySQL.
MySQL 5 Databases in Shared Web Hosting
The in-house built Hepsia Control Panel included with our Linux shared web hosting packages will permit you to take care of all your MySQL databases effortlessly. It requires just a couple of clicks to set up a completely new database and with one more click you could back it up if you would like to have a copy before you update your site, for instance. You'll be able to change the password, delete a database or permit remote access to it just as fast. For the latter option you'll be able to choose the IP addresses which will be able to connect to the database remotely so as to ensure that unauthorized people won't be able to access your info. If you'd like to view the database content or edit any cell or table via the Control Panel, you can use phpMyAdmin, an effective web-based interface. Using any of our script-driven apps shall also be very easy as our script installer will set up a database for the script that you have chosen automatically.
MySQL 5 Databases in Semi-dedicated Hosting
You'll be able to use any script that requires MySQL with any of our Linux semi-dedicated packages considering the fact that we have the newest version set up on all web servers - MySQL 5. Through our in-house built Hepsia web hosting CP, you'll be able to swiftly create or delete a database, change its password, back it up with one click or examine the hourly and daily access stats for it. If you'd like to manage the content of a database directly, not by using a script, you'll have two options - either working with the web interface of the phpMyAdmin tool, which is available inside the Control Panel, or using an app set up on your PC given that we support remote database access. For the aforementioned option, you'll have to add your IP address from the web hosting account first as an added level of security against unauthorized access to your data.