Databases

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

Unable to access Plesk: Permission denied /var/lib/mysql/mysql.sock
Unable to access MySQL/MariaDB databases on Plesk for Windows: Access denied for user 'admin'@'localhost' (using password: YES)
How to reinstall phpMyAdmin in Plesk for Linux
How to enable remote connections to MS SQL server on a Plesk server?
Database backup in Plesk fails because of missing MySQL/MariaDB user: The user specified as a definer does not exist
How to Add or Remove a Remote Database Server in Plesk?
Unable to install Plesk updates: Some database entries related to Panel IP addresses are corrupted
How to customize MySQL/MariaDB variables on a Plesk server?
Backup or migration fails in Plesk: Cannot dump database content of type 'mysql'
How to move a database to another subscription?
Unable to add remote Microsoft SQL Server to Plesk for Windows: A network-related or instance-specific error has occurred
Unable to log in to Plesk on Debian/Ubuntu-based distributions: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002)
Unable to open a subscription: No subscriptions are listed for your account; therefore, no operations are available.
Plesk shows SQLSTATE[HY000] [2002] No such file or directory on Linux: InnoDB: Unable to lock ./ibdata1 error: 11
Unable to upgrade to Plesk Onyx: 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server
How to increase the timeout limit of a login session in phpMyAdmin
When migrating to Plesk, MS SQL databases migrate to incorrect version of MS SQL server, or the error is shown: Unable to find mssql database server on target panel
How to create backups of all client's MySQL/MariaDB databases in Plesk?
How to access Plesk phpMyAdmin without logging in to Plesk?
Error while importing/restoring a database in Plesk: Unknown collation: 'utf8mb4_unicode_ci'
How to chroot MySQL/MariaDB client for users in Plesk?
Unable to start MySQL/MariaDB on a Plesk server: Cannot open tablespace table_name which uses space ID
How to enable the MySQL/MariaDB slow query log and analyze it on a Plesk for Linux server
MySQL/MariaDB crashes periodically on Plesk: Out of memory
Unable to connect remotely to MySQL/MariaDB on a Plesk server: Connection refused
How to import a MySQL/MS SQL database dump to a MySQL/MS SQL database in Plesk
An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'X' for key 'PRIMARY'
MySQL database import in Plesk fails: ERROR 1118 (42000): Row size too large
Plesk inaccessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused
The error in Plesk: ERR [panel] SQLSTATE[HY000] [2002] No such file or directory, Can't connect to local MySQL server through socket