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'
- 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, 5.5.63: 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 a MySQL database remotely?
- phpMyAdmin is not working: session_start(): Failed to read session data: files (path: ./tmp/session)
- 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?
- Unable to add PostgreSQL 10 in Plesk: UNENCRYPTED PASSWORD is no longer supported
- 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
- Cannot start MySQL: [ERROR] InnoDB: Datafile './dbname/table_name.ibd' is corrupted. Cannot determine the space ID from the first 64 pages
- 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
- Unable to start MySQL service: InnoDB: Waiting for the background threads to start
- MariaDB 10.3 support in Plesk