Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- 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 export MySQL dump for a domain in Plesk: insufficient privileges to SHOW CREATE
- 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
- Websites configured with PHP 7.2 or lower version fail to establish a database connection after updating MariaDB to v10.2.35 or v10.3.26: Malformed communication packet
- 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
- 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
- Exporting a database dump in Plesk fails: There is not enough space on the disk
- Unable to add new MSSQL database in Plesk: mssqlmng failed: Login failed for user 'jdoe' at (VADOConnection::open line 48) at Unable to ADO conect with connection string
- Microsoft SQL Server support in Plesk
- Plesk was partially removed by mistake along with psa database
- Unable to export mysql database: Unable to backup database 'db' (Error code 21)
- Which MariaDB versions are supported by Plesk?
- Unable to create a subscription/domain or switch the Hosting type to website hosting in Plesk: User account already exists
- Cannot create MS SQL database A file activation error occurred. The physical file name '\ example.mdf' may be incorrect
- Plesk Installer shows pre-upgrade warning: Given <password> is incorrect. Access denied for user ''@'localhost' (using password: NO)
- MariaDB does not start after update on November the 5th: Assertion failure in file
- Unable to repair Plesk database using Repair Kit: Checking the consistency of the Plesk database Inconsistency in the table 'ModuleSettings' for the column module_id
- MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded
- Unable to create reseller or change subscriber in Plesk: Unable to find row with id 1 in IP_Addresses table