You can easily create, remove, access databases in Websites & Domain > Databases.
You can easily create a database by stating its name. If you your hosting account has the permission to do this, you select the database type and the database web server on which the your desired database should be created.
You have the ability to choose a website on which the database will be utilized in the associated site box. This is appropriate if you have numerous of websites and databases, since you will view which database is accessed by which website exactly on the databases page.
Database Users in Windows Plesk
Each and every database must have at least one active user account connected with it. Or else it will be difficult to approach the database. You can easily create database user at the time of creating database by choosing Create a Database user checkbox. As a substitute, you can select a user later such as, if you wish to use one of the previous user accounts. To utilize the database user for obtaining any of the database of your website, select user has access to all databases inside the selected package.
How to Remove a Database from Plesk
In order to remove database, hit Remove Database under this database in Websites & domains> Databases. Keep in mind you can remove only the database and users of database that are not utilized by aby of the installed APS applications. If any of the link is not obtainable, it means that the database is utilized by an application and you will be able to remove it only after removing the particular application.
Accessing Databases in Plesk
Once you have created a database for your website and allocated a user for it, you can easily access if from Plesk panel utilizing the corresponding link from Websites & Domain > Databases. This link vary based on the type of database, for example:
- phpMydmin for MySQL databases
- phpMyAdmin for MySQL databases
- pgMyAdmin for PostgreSQL based databases.
Note: If any of the link is not present, get in touch with your web hosting service provider.
At the time of accessing a database with the help of the tools, Plesk panel automatically utilizes the relating database user credentials.
In case you wish to approach your database making use of other tools for example SQL server Management Studio, or just wish to give access of it to other applications, you have to provide these tools and apps with the following:
In order to connect to MySQL database or PostgreSQL database, you need to share the host name and the login details of users. To grab these details, hit connection info available under the database name.
If you want to connect to MSSQL server, you need to describe the Microsoft SQL server instance such as MSSQL Server 2012, MSSQL Server 2008, MSSQL server 2016 etc. To give an example, the host can be stated as domainname.com\MSSQLserver2008.
