Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- PostgreSQL: ERROR: unrecognized role option "createuser"
- Unable to connect to a remote PostgreSQL server: Could not connect to server: connection refused
- How to set a default database server for customers' databases in Plesk
- Cannot update master IP address for slave DNS zone in Plesk: DNS Inconsistent zone : The NS record IN NS has no address records (A or AAAA)
- Unable to clone a WordPress instance that contains VIEW with a database user as DEFINER in its database: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
- Failed to copy database in Plesk: mssqlmng failed: 'user_name' is not a valid login or you do not have permission
- 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'
- Does Plesk support MariaDB 10.2?
- Upgrade of MySQL schema with mysql_upgrade fails with the error: Error: Incorrect database name '#mysql50#.ssh'
- 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
- Unable to remove a database marked as "Used by an installed web app" in Plesk
- 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: Native table 'performance_schema'.'session_variables' has the wrong structure
- How to provide CREATE ROLE permission for MSSQL database users
- Unable to add PostgreSQL server to Plesk: A database server with this combination of host address and port number is already registered
- 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
- 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?