123ArticleOnline Logo
Welcome to 123ArticleOnline.com!
ALL >> Internet-Marketing >> View Article

Plesk - Creating Databases And Accessing

Profile Picture
By Author: Girish Neeluru
Total Articles: 2
Comment this article
Facebook ShareTwitter ShareGoogle+ ShareTwitter Share

You can easily create, remove, access databases in Websites & Domain > Databases.
You can easily create a database by stating its name. If your Cloud hosting(https://anycloud.hostingraja.in/) account has the permission to do this, you select the database type and the database web server on which 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 a database by choosing to Create a Database user check box. 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 databases of your website, the select user has access to all databases inside the selected package.

How to Remove a Database from Plesk

In order to remove the database, hit Remove Database under this database in Websites & domains> Databases. Keep in mind you can remove only the database and users of the database that is not utilized by any of the installed APS applications. If any of the links 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:

PHPMyAdmin for MySQL(https://www.mysql.com/) databases
phpMyAdmin for MySQL databases
pgMyAdmin for PostgreSQL based databases.

Note: If any of the links are not present, get in touch with your web hosting service provider.

At the time of accessing a database with the help of the tools, the Plesk(https://www.plesk.com/) 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 a MySQL database or PostgreSQL database, you need to share the hostname 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.

Total Views: 48Word Count: 484See All articles From Author

Add Comment

Internet Marketing Articles

1. Erp Virtual Server
Author: arpithappu

2. 5 Pointers For Finding The Right Digital Marketing Agency In Kolkata
Author: Soumya Banerjee

3. Signs You Should Invest In Digital Marketing
Author: Nik Gallagher

4. Web Design And Credibility Of Your Website
Author: Nik Gallagher

5. Sms Campaign | Mobile Sms Campaign Services
Author: Abdul Rehman

6. How To Get An Interview Call From A Digital Marketing Agency In India
Author: Soumya Banerjee

7. 10 Tips To Start And Improve Youtube Channel For Beginner
Author: keerthi

8. 5 Digital Marketing Techniques To Grow Your Local Business
Author: malikaa

9. Wordpress Blog: Something You Would Not Want To Miss About!
Author: Willson Robin

10. Essential Advice On Downloading The Videos From Youtube
Author: Video downloadr

11. Seo Trends 2020 - Stay Updated And Ahead Of Competition
Author: Chris Walker

12. Do’s And Dont’s Of Seo That Should Be Followed In 2020
Author: Chris Walker

13. How Seo Marketing Can Magnify Your Business?
Author: Chris Walker

14. Ivr Solution | Intellexal Solutions
Author: Abdul Rehman

15. Voice Call | Intellexal Solutions
Author: Abdul Rehman

Login To Account
Login Email:
Password:
Forgot Password?
New User?
Sign Up Newsletter
Email Address: