Accessing Databases¶
After you have created a database and assigned a database user to it, you can access it from Plesk using the corresponding link in Websites & Domains > Databases. The links differ depending on the database type:
- phpMyAdmin for MySQL databases
- pgMyAdmin for PostgreSQL databases
- Local database clients (for example, HeidiSQL or SQL Server Management Studio (SSMS)) for SQL Server databases
Note
If the link is missing, contact your hosting provider.
When accessing a database with these tools, Plesk automatically uses the corresponding database user credentials.
If you want to access your database using other tools (such as 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 view this information, click the Connection Info link under the database name.
- To connect to Microsoft SQL Server, you will also need to specify the
Microsoft SQL Server instance. For Microsoft SQL Server 2012, 2014
and 2016, Plesk uses the named instances (
MSSQLSERVER2012
,MSSQLSERVER2014
,MSSQLSERVER2016
respectively). For example, the host can be specified asmydomain.com\MSSQLSERVER2012
or123.123.123.123\MSSQLSERVER2012.