Plesk is a control panel available on Linux-based hosting Accounts and also servers. It easily manages many aspects of your account, including the files, applications, and servers, it’s also hosted on your account or server. The operating systems supporting Plesk include Fedora, Red Hat, Debian, FreeBSD, SuSE, CentOS, Ubuntu, and Windows.
The database in Plesk:
There are many databases can be installed and create multiple databases in Plesk. Such as MySQL, MSSQL, and so on. We can access the database using phpMyAdmin and LittleAdmin also. Creation and deletion of the database in the graphical user interface as well as in the command-line interface is the method of approaching to perform the tasks on Plesk Windows hosting control panel. To perform this action we need to the database.exe utility is need on command line interface.
The Database command is executed via the utility. The database utility supports the few functions they are:
- Creating a database
- Deleting a database
- adding a database
- removing a database
- adding access control for MySQL or PostgreSQL user
- removing access control for MySQL or PostgreSQL user
- edit database user credentials
- setting charset for PostgreSQL database.
To delete database db-name from the database server:
plesk bin database --remove db-name
plesk bin database -r db-name