Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- How to connect to MSSQL server from Plesk interface?
- Plesk update failed: There is a MySQL server running, but we failed in our attempts to stop it
- How to upgrade MySQL 5.6 to 5.7 on Plesk Onyx for Windows?
- How to add an existing database to Plesk from the remote MySQL server to a subscription
- How to see BLOB fields as text in PHPMyadmin?
- How to enable remote access to PostgreSQL server on a Plesk server?
- Migration fails: MySQL server has gone away
- PostgreSQL: ERROR: unrecognized role option "createuser"
- 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'
- 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 change the max_user_connections value in MySQL/MariaDB on a Plesk server
- 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
- 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"