Databases

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

MySQL/MariaDB service fails to start on Plesk server or other operations fail due to corrupted database
Cannot restore database on Plesk server: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
How to add an additional local MySQL/MariaDB server in Plesk on Windows?
How to add an already installed Microsoft SQL server in Plesk
How to add a new instance of existing MS SQL Server to Plesk
How to change default MySQL/MariaDB directory %plesk_dir%\Databases\MySQL\data to another one on Plesk for Windows?
Cannot restart MySQL/MariaDB service from Plesk administrator panel on Linux
A MySQL/MariaDB query executed in phpMyAdmin/PHP script fails when the ONLY_FULL_GROUP_BY SQL mode is configured
Is it possible to add Microsoft SQL Server in Plesk for Linux?
Failed to login to the client's MySQL/MariaDB using Plesk admin credentials
Database import fails: There can be only one TIMESTAMP column
Attempt to connect or drop psa database hangs: Native table 'performance_schema'.'session_variables' has the wrong structure
How to change the innodb_log_file_size setting in MariaDB
Why a database marked as "Used by an installed web app" in Plesk cannot be manually removed?
How to register an existing database in Plesk
How to change the max_user_connections value in MySQL/MariaDB on a Plesk server
MySQL/MariaDB schema upgrade error: Incorrect database name '#mysql50#.ssh'
Plesk is not accessible and MariaDB service cannot start: InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
Is it possible to use a remote database server for all databases including system ones on Plesk for Linux?
Cannot update master IP address for slave DNS zone in Plesk: DNS Inconsistent zone : The NS record IN NS has no address records (A or AAAA)
How to set a default database server for customers' databases in Plesk
Migration fails: MySQL server has gone away
How to enable remote access to PostgreSQL databases hosted in Plesk
How to import a database from a remote MariaDB server into a Plesk subscription
Database importing hangs in Plesk: Got an error reading communication packets
How to import PostgreSQL database dump on Plesk for Linux server?
myLittleAdmin from a Plesk domain is unreachable at mssql.example.com: ERR_NAME_NOT_RESOLVED
How to create a database in Plesk
Plesk for Linux interface is inaccessible: Can't init tc log
Unable to copy/back up a database in Plesk: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table