Databases

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

How to troubleshoot slow performance of MySQL/MariaDB on a Plesk server?
Vulnerability in Plesk’s MS SQL database user password update mechanism
MSSQL 'sa' user locked out: Login failed for user 'sa'
Can't install MariaDB in Plesk Windows: FATAL ERROR: Can't create data directory 'N:\MySQL-Data' (one or more intermediate directories do not exist)
Unable to log in to Plesk: Table 'psa.smb_componentUpdates' doesn't exist in engine
Cannot see remote MySQL/MariaDB database in Plesk Customer Panel
MariaDB upgrade option is missing under Tools & Settings > Database Servers
On a Plesk server with WP Toolkit, a prefix is added to the name of a cloned database
Cannot use database upgrade tool or Performance Booster for MariaDB 11.4
PostgreSQL: ERROR: unrecognized role option "createuser" LINE 1
Can not connect to the database server: can't connect to mysql server on example.com (10061)
Error after installing/updating PostgreSQL on a Plesk server: '/lib64/libpq.so.5: no version information available'
Unable to upgrade MariaDB via Plesk: Found row where the auto_increment column has the value 0
Unable to restore the Microsoft SQL database: Log file size in backup is greater than the maximum allowed size
MariaDB fails to restart after upgrade from 10.5 or below to 10.6 or above using upgrade tool in Plesk: [ERROR] Can't start server: Bind on TCP/IP port. Got error: 22: Invalid argument
Error when restoring a MariaDB database in Plesk: Unable to flush stdout: Broken pipe
MariaDB pre-upgrade check failed: The following package manager configuration files contain options that may result in an upgrade failure
How to configure the MariaDB unit in order to keep it from getting killed by OOM?
MySQL does not start after replacing MariaDB: MySQL has been frozen to prevent damage to your system
Unable to check the Mysql/Mariadb status after upgrade: ERROR! MariaDB is running but PID file could not be found
Scheduled Plesk Backups fail to make database dump: Error: Forcing protocol to TCP due to option specification.
Error in the /var/log/maillog after upgrading MySQL on Plesk on Cloudlinux server: /usr/lib64/mysqlclient/libmysqlclient.so.18: no version information available
Unable to dump database manually or during a backup process on Plesk: Error 2013: Lost connection to server during query when dumping table example at row: 0
Is it possible to downgrade MariaDB from version 10 to version 5?
"Allow local MySQL server to accept external connections" checkbox disappears after activation
How to copy a MySQL/MariaDB database in Plesk?
Website does not work: Specified driver could not be loaded due to system error 5: Access is denied. (MySQL ODBC 5.1 Driver, C:\Program Files (x86)\MySQL\Connector ODBC 5.1\myodbc5.dll).
MariaDB is not able to start: Got error '144 "Table is crashed and last repair failed"' for './mysql/global_priv'
Domain hosting settings can't be opened in Plesk: Internal error: Full path is undefined. Inconsistency in the table 'domains' for the column id: No rows in the table 'hosting' with dom_id
Unable to change the IP address type in Plesk: IP address 203.0.113.2 is already allocated to user