Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Unable to create object in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry for key 'PRIMARY'
- 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?
- Unable to manage database users in Plesk: The user specified as a definer ('root'@'localhost') does not exist
- 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
- 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
- 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)
- Database and domain relation is not reflecting on subscription page properly
- Unable to choose PostgreSQL database server in Plesk Multi Server
- 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
- How to find a path to website's folder on the server with DB query?
- How to upgrade MariaDB 10.0 to 10.1 on CentOS 7
- How to assign multiple database users to another database?
- Unable to configure PostgreSQL in Plesk Onyx on Ubuntu 18.04: The test connection to the database server has failed
- How to grant the database user access to database of the other subscription?
- Integration with MSSQL breaks in Plesk Onyx 17.8 when PCI compliance settings in use: ODBCError 08001: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error
- Unable to create database users if default db server is set to NONE: setMultiOptions() must be of the type array, null given
- How to rename a MySQL database on a Plesk server