Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- How to enable remote access to PostgreSQL server on a Plesk server?
- Migration fails: MySQL server has gone away
- Unable to upgrade MySQL: Access denied for user 'root'@'localhost' (using password: NO)
- 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: 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?
- Default settings for remote access of database users does not affect MS SQL and PostgreSQL database users
- 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 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
- phpMyAdmin error: "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 access Plesk: Plesk MySQL process is stuck
- Unable to add database in domain: Try to establish connection failed
- How to change the innodb_log_file_size value in MySQL/MariaDB