Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Plesk inaccessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused
- MySQL database import in Plesk fails: ERROR 1118 (42000): Row size too large
- How to add db_owner role to newly created users
- An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'X' for key 'PRIMARY'
- How to import a MySQL/MS SQL database dump to a MySQL/MS SQL database in Plesk
- Unable to connect remotely to MySQL on a Plesk server: Connection refused
- MySQL crashes periodically on Plesk: Out of memory
- How to enable the MySQL slow query log and analyze it on a Plesk for Linux server
- Unable to start MySQL: Cannot open tablespace table_name which uses space ID
- How to chroot MySQL client for users in Plesk?
- Error while importing/restoring a database in Plesk: Unknown collation: 'utf8mb4_unicode_ci'
- How to access phpMyAdmin shipped in Plesk without login to Plesk URL itself?
- How to automatically create backups of all databases of customer MySQL/MariaDB server in Plesk?
- 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 increase the timeout limit of a login session in phpMyAdmin
- Unable to upgrade to Plesk Onyx: 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server
- Plesk shows SQLSTATE[HY000] [2002] No such file or directory on Linux: InnoDB: Unable to lock ./ibdata1 error: 11
- Unable to open a subscription: No subscriptions are listed for your account; therefore, no operations are available.
- 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 add remote Microsoft SQL Server to Plesk for Windows: A network-related or instance-specific error has occurred
- How to move a database to another subscription?
- Backup or migration fails in Plesk: Cannot dump database content of type 'mysql'
- How to set custom parameter value for MySQL server on Plesk
- Unable to install Plesk updates: Some database entries related to Panel IP addresses are corrupted
- How to add and configure, or remove a remote database server in Plesk?
- Database backup in Plesk fails because of missing MySQL user: The user specified as a definer does not exist
- Unable to start MSSQL Server: Server TCP provider failed to listen on [ 'any' <ipv6> 1433]. Tcp port is already in use
- How to enable remote connections to MS SQL server on a Plesk server?
- How to reinstall phpMyAdmin in Plesk for Linux
- Unable to access clients' MySQL databases on Plesk for Windows: Access denied for user 'admin'@'localhost' (using password: YES)