Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- How to fix InnoDB corruption cases for the MySQL databases on Plesk for Linux?
- Unable to start MariaDB 10.6 on a Plesk server: Bind on TCP/IP port. Got error: 22: Invalid argument
- 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.
- In Plesk, dumps of MySQL databases with DEFINERs/TRIGGERs are exported with incorrect syntax of queries that should create DEFINERs/TRIGGERs
- Unable to repair domains in Plesk using "plesk repair db" utility: The following domains are assigned to already removed IP addresses
- 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 add MS SQL Server in Plesk: Login failed for user 'administrator'
- 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
- 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 export MySQL dump for a domain in Plesk: insufficient privileges to SHOW CREATE
- Unable to access Plesk with 500 error message: [2002] No such file or directory
- A PHP-based website fails to open: Failed to connect to MySQL: Access denied for user 'jdoe'@'localhost' (using password: YES)
- MySQL service fails to start on a Plesk server: Table 'mysql.user' doesn't exist
- Unable to add external database server in Plesk: 1044 Access denied for user
- How to restore Plesk system databases from a Plesk daily/pre-upgrade dump
- Restoration of a database fails in Plesk: errno: 140 "Wrong create options"
- Unable to export database via phpMyAdmin in Plesk: Argument 5 passed to PhpMyAdmin\Export::getFilenameAndMimetype() must be of the type string, null given
- How to switch database server from MySQL to MariaDB on Plesk Obsidian for Windows
- Is it possible to install PostgreSQL 10.x on CentOS 7 with Plesk?
- Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools
- Backup failed with the error in Plesk: 1049 Unknown database 'example'
- Checking the consistency of the Plesk database shows: Inconsistency in the table 'smb_roleServicePermissions' for the column servicePermissionId: No rows in the table 'smb_servicePermissions' with id = 1
- Remote connection to MySQL database hosted on Plesk fails: ERROR 2003 (HY000): Can't connect to MySQL server
- MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384
- Domains show Plesk default page: web service cannot operate: the IP address list with ID 101 is empty
- Cannot import database dump in Plesk: Index column size too large. The maximum column size is 767 bytes
- InnoDB corruption occurs in MariaDB on Plesk server after reboot: Unspecified GSS failure
- Microsoft SQL Server support in Plesk
- Plesk was partially removed by mistake along with psa database
- Can't connect MSSQL database: the client and server cannot communicate, because they do not possess a common algorithm