Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Plesk Update failed: There is a MySQL server running, but we failed in our attempts to stop it.
- Is it possible to replace MariaDB 5.5, 10.X with MySQL 5.6, 5.7 on a Plesk server
- How to upgrade MySQL 5.6 to 5.7 on Windows
- How to add an existing database from the remote MySQL server to a subscription
- Auto-login is not working in phpMyAdmin when logging in from Plesk
- 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
- 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)
- 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
- 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
- Unable to create a customer database via CLI on Plesk Multi Server