Databases

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

How to change the MySQL/MariaDB default charset from "utf8_unicode_ci" to "utf8mb4_unicode_ci" in MySQL in Plesk for Linux?
Does implementation of MySQL/MariaDB database encryption affect Plesk functionality?
Unable to access a website or access Plesk System Updates: Error 500 MySQL server has gone away
MSSQL database is not visible or cannot be opened in myLittleAdmin on Plesk server: Cannot open user default database
How to allow/deny customers to choose a database server when creating a database in Plesk
Cannot start MariaDB on Plesk server: the directory /var/lib/mysql is not empty, so initialization cannot be done
Database import or WordPress cloning fails: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Is it possible to have multiple MySQL/MariaDB instances on Plesk for Linux?
A migrated database in Plesk cannot be accessed via phpMyAdmin: Access denied for user
Unable to create reseller or change subscriber in Plesk: Unable to find row with id 1 in IP_Addresses table
Plesk Update fails: Table 'mysql.innodb_index_stats' doesn't exist in engine
Can't initialize PostgreSQL in Plesk: start service postgresql failed psql: could not connect to server:
Unable to create a subscription/domain or switch the Hosting type to website hosting in Plesk: User account already exists
Unable to remove a MSSQL, PostgreSQL or MySQL / MariaDB server from the Plesk GUI: A database server cannot be deleted while there are databases or database users hosted on it
Microsoft SQL Server support in Plesk
Error in Webserver Configurations Troubleshooter: SSLCertificateFile: file does not exist or is empty
InnoDB corruption occurs in MariaDB on Plesk server after reboot: Unspecified GSS failure
Can't import database: Index column size too large. The maximum column size is 767 bytes
Domains show Plesk default page or mail services misbehave: web service cannot operate: the IP address list with ID 101 is empty
Unable to access phpMyAdmin in Plesk: Failed to store CSRF token in session! Probably sessions are not working properly
Backup failed with the error in Plesk: 1049 Unknown database 'example'
Is it possible to install PostgreSQL 10.x or higher with Plesk?
How to switch from MySQL to MariaDB on Plesk for Windows
Unable to create a database in Plesk: A database with the name example_db already exists
Restoration of a database fails in Plesk: errno: 140 "Wrong create options"
How to restore Plesk system databases from a Plesk daily / pre-upgrade dump
Unable to add external database server in Plesk: 1044 Access denied for user
MySQL/MariaDB service fails to start on a Plesk server: Table 'mysql.user' doesn't exist
A PHP-based website on Plesk server fails to open: Failed to connect to MySQL: Access denied for user 'jdoe'@'localhost' (using password: YES)
Unable to access Plesk with 500 error message: [2002] No such file or directory