Databases

Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.

Unable to export MySQL/MariaDB dump for a domain in Plesk: insufficient privileges to SHOW CREATE
Unable to remove a MSSQL from Plesk: Login 'jdoe' owns one or more database(s). Change the owner of the database(s) before dropping the login.
Unable to delete MS SQL database in Plesk: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks
PostgreSQL server is missing in the Database servers menu in Plesk with Web Admin license edition
Error in Diagnose & Repair tool: The following domains are assigned to already removed IP addresses. Reassign the domains to existing IP addresses
Unable to add MS SQL Server in Plesk: Login failed for user
Unable to restore the Plesk psa database: ERROR 1813 (HY000) at line 104: Tablespace for table '`psa`.`tablename`' exists. Please DISCARD the tablespace before IMPORT
Unable to repair domains in Plesk using "plesk repair db" utility: The following domains are assigned to already removed IP addresses
In Plesk, dumps of MySQL/MariaDB databases with DEFINERs/TRIGGERs are exported with incorrect syntax of queries that should create DEFINERs/TRIGGERs
MySQL package fails to update on Plesk server: The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
Plesk database servers menu shows warning: Unable to determine the TCP port number used by Microsoft SQL server 'localhost'
Plesk or system update fails on Linux: http://yum.mariadb.org/10.1/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
Unable to start MariaDB 10.6 on a Plesk server: Bind on TCP/IP port. Got error: 22: Invalid argument
MariaDB cannot start on Plesk server: redo log file exists
Unable to create domain: A specified logon session does not exist. It may already have been terminated. (Exception from HRESULT: 0x80070520)
Are there any alternatives to myLittleAdmin in Plesk for Windows?
Unable to open Database Servers list on Plesk as it redirects to Home or fail with: Type GraphQL Error - Dependent row(s) 'Domains.id = 1029' isn't found for 'data_bases.dom_id = 1029'.
Plesk Update fails: NOKEY Importing GPG key 0xC74CD1D8