MySQL is among the most widespread database administration systems on the market. A database is a set of cells with info which are organized in tables and the management system is the piece of software that links the data to a script app. As an example, a forum stores all usernames, avatars, posts etc inside a database and each time a website visitor opens a specific thread, the forum script connects to the database and “calls” the content which should be accessible on a certain page. MySQL is extremely popular due to its excellent efficiency, simplicity of use and the fact that it can operate with a lot of popular scripting languages such as PHP, Python, Perl, and so forth. All dynamic Internet sites which are developed with a script-driven application need some form of database and a lot of the most widely used ones such as Joomla, Moodle, Mambo and WordPress employ MySQL.
MySQL 5 Databases in Shared Website Hosting
The in-house built Hepsia Control Panel included with our shared website hosting plans allows you to control all your MySQL databases effortlessly. It takes only a couple of mouse clicks to set up a brand new database and with just one more click you can back it up if you'd like to have a copy before you update your website, for instance. You shall be able to change the password, erase a database or allow remote access to it just as easily. For the latter option you'll be able to choose the IP addresses that will be able to connect to the database remotely in order to make sure 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 through the CP, you may use phpMyAdmin, an efficient web-based interface. Using any of our script-driven applications will also be very easy as our script installer will create a database for the script that you have chosen automatically.
MySQL 5 Databases in Semi-dedicated Servers
All our semi-dedicated hosting plans provide MySQL 5 support and the administration of your databases will be quite simple. With just a couple of mouse clicks you'll be able to create a whole new database, delete an existing one or alter its password. The Hepsia hosting Control Panel shall also give you access to more advanced functions including a one-click backup and remote access. For the latter option, you could add only the IP address of your PC to be sure that no one else will be able to access your information. In this way, you can handle the content of any database inside the account using any application on your personal computer. If you prefer to do this online, you could use the phpMyAdmin tool, which is available via Hepsia. You shall also be able to see hourly and daily MySQL stats, that will show you how your Internet sites perform and if any one of them should be optimized.