Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Is it possible to use a remote database server for Plesk and system databases?
- Unable to import a database dump in Plesk: Unknown collation: 'utf8mb4_unicode_ci'
- MariaDB 10.2 support in Plesk
- Upgrade of MySQL schema with mysql_upgrade fails with the error: Error: Incorrect database name '#mysql50#.ssh'
- Plesk for Windows is not accessible: No connection could be made because the target machine actively refused it
- Unable to login to Plesk after MySQL upgrade: unknown variable 'innodb_additional_mem_pool_size='
- How to modify value of max_user_connections for MySQL/MariaDB?
- How to register an existing database in Plesk
- How to remove a database marked as "Used by an installed web app"?
- Error is returned when executing FLUSH PRIVILEGES in Plesk via phpMyAdmin: "Access denied; you need (at least one of) the RELOAD privilege(s) for this operation"
- Unable to import a database dump: Cannot add or update a child row: a foreign key constraint fails
- Unable to add the database for a domain: Unable to find row with id NaN in DatabaseServers table
- How to change the innodb_log_file_size value in MySQL/MariaDB
- Plesk is inaccessible and it is not possible to start MySQL/MariaDB: MySQL system database not found in /var/lib/mysql
- Attempt to connect or drop psa database hangs
- How to provide CREATE ROLE permission for MSSQL database users
- [BUG] Unable to add PostgreSQL server to Plesk: A database server with this combination of host address and port number is already registered
- [BUG] Copy database not working: no errors are shown in Plesk GUI
- Website using MSSQL is inaccessible: SqlException (0x80131904): The SELECT permission was denied on the object
- Database import fails: There can be only one TIMESTAMP column
- Unable to restore database backup InnoDB: Error: Table "mysql"."innodb_table_stats"
- Is it possible to downgrade MySQL/MariaDB on Plesk server?
- Failed to login to the client's MySQL using Plesk admin credentials
- Failed to access MySQL via SSH using root account
- Cannot export database dump from Plesk: The user name or password is incorrect (Error code 21)
- Is it possible to add MS SQL server in Plesk based on Linux system?
- Exporting database dump in phpMyAdmin on Plesk server fails: Your export is incomplete, due to a low execution time limit at the PHP level
- A MySQL query executed in phpMyAdmin/PHP script fails when the ONLY_FULL_GROUP_BY SQL mode is configured
- Cannot restart MySQL service from Plesk administrator panel on Linux
- How to create a database dump using PHPMyAdmin in Plesk?