Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'X' for key 'PRIMARY'
- How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux?
- Unable to create MSSQL databases: There are no available resources of this type (MySQL databases) left
- PHPmyadmin templates are removed after updating Plesk
- MariaDB does not start after update on November the 5th: Assertion failure in file
- Error on attempt to create new database or user: Unable to find row with id in DatabaseServers table
- MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded
- MSSQL databases take long time to load on Plesk server
- Cannot add PostgreSQL with custom port in Plesk: Is the server running locally and accepting connections on Unix domain socket
- MySQL instance is stopped and set as Manual Startup during Updates
- Unable to create Mysql database in Plesk: Database user name is invalid. Only latin letters are allowed in the database user name
- How to increase upload dump size in phpMyAdmin?
- How to allow/deny customers to choose a database server when creating a database in Plesk
- Error when running a query inside PHPMyAdmin in Plesk for Windows Server: unrecognized statement type (near lock)
- Unable to rename table in phpMyAdmin under Domain: Cannot read property 'substring' of undefined
- Websites show garbled characters after Plesk update
- Multiple Vulnerabilities in Oracle MySQL Server before 5.7.25, 5.6.43: potential Unauthorized access
- Unable to connect to Plesk server via FTP to any account
- 'undefined' is shown next to Database name when installing WordPress on subdomain in Plesk
- Unable to import a MySQL dump via phpMyAdmin: Operation hangs on FOREIGN_KEY_CHECKS
- Option to export table in SQL format is missing in phpMyAdmin on Plesk
- How to enable the MySQL slow query log on Windows Server
- Unable to import the database dump: Access denied for user
- Cannot open phpMyAdmin designer: Error code: 500 Error text: error (rejected)
- PostgreSQL support in Plesk
- How to manage customers' databases in Plesk
- How to fix InnoDB corruption cases for the MySQL databases on Plesk for Windows?
- How to connect to MySQL database hosted on Plesk server from remote machine?
- It is not possible to log into phpMyAdmin: failed to read session data: files (path: @@PMA_TEMP_DIR@@/session)
- Plesk and websites are not accessible due to high CPU load by MySQL processes