Databases

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

How to get a list of subscriptions and their IP addresses on Plesk server?
How to change the password of a database user in Plesk
The size of a MySQL or MariaDB database in "View More Statistics" does not match the size from the "Database" tab in Plesk
How to list databases with their subscription/domain/owner using a SQL query in Plesk
Cannot add MySQL/MariaDB database in Plesk Customer Panel
How to check what website causes MySQL/MariaDB to use resources in Plesk?
MariaDB fails to start: Aria engine is not enabled or did not start
Which MySQL versions are supported by Plesk?
How to move a database to a different database server within Plesk?
myLittleAdmin on Plesk opens insecure HTTP page
phpPgAdmin is not available for installation in Plesk
Is it possible to setup MySQL/MariaDB replication in Plesk?
Error in MySQL log files on Plesk server: Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14
How to retrieve administrator's Plesk database password on Plesk 17.8 for Windows and higher?
Cannot access database with phpMyAdmin or restore it: Access denied for user 'jdoe'@'localhost' (using password: YES)
Unable to start MySQL/MariaDB on Plesk server because of lack of RAM: mysqld dead but subsys locked
Unable to import MySQL/MariaDB dump using Import Dump feature in Plesk: ERROR 1227 (42000) at line 1421: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
How to increase the MySQL/MariaDB max_connections value?
Unable to register remote MySQL/MariaDB server in Plesk: Host is not allowed to connect to this MySQL server
Import/export of a remote MS SQL Server database fail in Plesk: Unable to connect to the network share Unable to open network connection: A specified logon session does not exist. It may already have been terminated
Unable to start MySQL/MariaDB service: InnoDB: Waiting for the background threads to start
How to rename a MySQL/MariaDB database in Plesk for Linux
Is it possible to secure MySQL/MariaDB connections?
Can't start MariaDB: Assertion failure in thread 908 in file fut0lst.ic
How to connect to MySQL/MariaDB database hosted on Plesk server from remote machine?
How to manage customers' databases in Plesk
Is it possible to replace MySQL with MariaDB and vice versa on a server with Plesk?
PostgreSQL support in Plesk
Migration fails: Failed to copy content of database: Specified key was too long; max key length is 767 bytes
How to enable the MariaDB slow query log on Windows Server with Plesk?