Knowledgebase

Creating Databases

Creating and Removing Databases

To create a new database on a customer account:

1. If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace.
2. Click the Websites & Domains tab.
3. Click Databases (in the Advanced Operations group).
4. Click Add New Database.
5. Enter a name for the database.

   We recommend that you choose a name that starts with a Latin alphabet symbol and comprises only alphanumeric and underscore symbols (up to 64 symbols).

6. Select the database type that you are going to use: MySQL, PostgreSQL or Microsoft SQL Server. Click OK.
7. To set up database administrator's credentials, click Add New Database User.
8. Type a user name and a password that will be used for accessing the contents of the database.
9. Click OK.

To remove a database with its contents:

1. If you are subscribed to several hosting packages and have access to several webspaces associated with your account, in the Subscription menu at the top of the screen, select the required webspace.
2. Go to the Websites & Domains tab > Databases.
3. Select a checkbox corresponding to the database that you want to remove.

   If the required checkbox appears grayed out, this means that this database is used by a web application and you can remove it only by removing the respective application.

4. Click Remove.
5. Confirm removal and click OK.

Accessing Databases

After you created a database and assigned a database user to it, you can access it from Panel using the Webadmin link on the Websites & Domains tab > Databases > database name page. In this case, Panel automatically uses the corresponding database user credentials.

If you want to access your database using some other tools (like SQL Server Management Studio) or to give some applications access to it, you will need to provide these tools and applications with the following:

• To connect to MySQL and PostgreSQL, you will need to provide the host name (or IP address) and the database user login and password.
• To connect to Microsoft SQL Server, you will also need to specify the Microsoft SQL Server instance. For Microsoft SQL Server 2008, Panel uses the MSSQLSERVER2008 named instance. Therefore, the host can be specified as mydomain.com\MSSQLSERVER2008 or 123.123.123.123\MSSQLSERVER2008. For Microsoft SQL Server 2005, Panel uses the default instance (MSSQL 2005), and you do not need to specify the instance name.