Databases are a vital part for any website to run smoothly, your webhost will offer you control panel with your hosting account using which you can create and manage all hosting related stuffs. Creating and managing databases is one of the important part that your hosting control panel would take care of. If you are on windows hosting platform then you will get plesk as your best web hosting control panel using which you can easily create your databases and can manage them. Plesk gives you the ability to create and manage MySQL, MSSQL databases in both its Linux and Windows forms; you can also create PostgreSQL databases if you have required add-ons with your control panel.
Usually PostgreSQL is found with Linux, and MSSQL is for Windows email hosting only hence you have to get addons if you want to use PostgreSQL on your windows hosting plan. If you are using MySQ databases then you will have PHPMyAdmin for managing your MySQL databases with your plesk hosting account. If you are using MSSQL databases with your windows hosting account then you will have ASP.NET Enterprise Manager using which you can view and manage your MSSQL databases which are hosted on your windows hosting account.
Usually you would be using some dynamic webpage programming language which would be fetching data from your databases and providing it to your website visitors. You can also store and can update/mange/edit all your databases. Plesk control panel allows you to create users so that databases you have created can be accessed by scripts you have created, without such database users, all scripts and other applications cant access your database. You can also create multiple databases using your plesk control panel and can manage them independently.
Posted under Managing Plesk, Plesk Control panel, Windows Hosting with Plesk
This post was written by on October 6, 2009
