Creating Databases

Watch the video tutorial

Plesk allows you to create and remove databases on the Websites & Domains tab > Databases page.

You can create a database by specifying its name. If your subscription grants you the corresponding permission, you can choose a database type and the database server on which the database should be created.

A database must have at least one user account associated with it. Otherwise, it will be impossible to access the database. You can create a database user while creating a database by selecting the Create a database user checkbox. Alternatively, you can clear the checkbox and select a user later, for example, if you want to use one of the existing user accounts. For more information, see Database User Accounts.

Note that you can remove only the databases and database users that are not used by APS apps. If the required checkbox appears grayed out, it means that this database is used by an app and you can remove it only by removing the respective app.

Accessing Databases

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

Note: If the Webadmin link is missing, contact your hosting provider.

If you want to access your database using other tools (like SQL Server Management Studio) or want to give other 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, Plesk 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, Plesk uses the default instance (MSSQL 2005), and you do not need to specify the instance name.