Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- 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)
- How to add Windows Administrator to MSSQL server
- Unable to export a dump of MSSQL database: BACKUP DATABASE permission denied (Error code 21)
- Can the customers execute queries to their MSSQL databases in Plesk?
- 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 copying of a database: mssqlmng failed: 'user_name' is not a valid login or you do not have permission
- Unable to import a database dump in Plesk: Unknown collation: 'utf8mb4_unicode_ci'
- Inconsistency in Plesk Database: No rows in the table 'db_users' with id
- 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
- Deleted STRICT_TRANS_TABLES setting in MySQL gets reverted after Plesk updates.
- 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"?
- Where PostgreSQL configuration file can be found?
- Unable to restore database backup: ERROR 1049 (42000): Unknown database
- 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
- MS SQL instance version is missing in Plesk
- Unable to add database in domain: Try to establish connection failed
- How to change the innodb_log_file_size value in MySQL/MariaDB
- MS SQL database import fails: Login failed for user 'sa'
- Plesk is inaccessible and it is not possible to start MySQL/MariaDB: MySQL system database not found in /var/lib/mysql
- Unable to access phpMyAdmin on a Plesk for Linux server after upgrading OS: Permission denied
- Attempt to connect or drop psa database hangs
- Unable to open PHPMyAdmin: Call to a member function getName() on null (ThemeManager.php:507)
- 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