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"
- PostgreSQL could not connect to server: connection refused
- Cannot update master IP address for slave DNS zone: DNS Inconsistent zone : The NS record IN NS has no address records (A or AAAA)
- Website application shows: TCP Provider: No connection could be made because the target machine actively refused it
- Unable to export a dump of MSSQL database: BACKUP DATABASE permission denied (Error code 21)
- Can customers execute queries to their MSSQL databases on Plesk?
- Default settings for remote access of database users does not affect MS SQL and PostgreSQL database users
- Unable to access Plesk: SQLSTATE[HY000] [2002] No such file or directory: Table 'mysql.host' doesn't exist
- 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'
- Plesk is not accessible and MariaDB service cannot start: InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
- 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
- Unable to create a customer database via CLI on Plesk Multi Server
- 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
- Does Plesk backup MongoBD?
- MS SQL instance version is missing in Plesk
- Unable to access Plesk: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it