Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- How to add an additional local MySQL server in Plesk on Windows?
- Cannot restore database on Plesk server: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
- MySQL service fails to start on Plesk server or other operations fail due to corrupted database
- The error in Plesk: ERR [panel] SQLSTATE[HY000] [2002] No such file or directory, Can't connect to local MySQL server through socket
- 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?
- How to change the default MSSQL directory for database files in Plesk?
- Error while importing/restoring a database in Plesk: Unknown collation: 'utf8mb4_unicode_ci'
- MySQL fails to start after an upgrade: mysql.user table is damaged
- 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. Please contact your service provider for assistance with subscribing to the services
- 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?
- MySQL Server or MSSQL Server service cannot start in server with Plesk: Error 1067: The file system structure on disk is corrupt and unusable
- Backup or migration fails in Plesk: Cannot dump database content of type 'mysql'
- How to set custom parameter value for MySQL server on Plesk?