Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Database query error shown when loading the domains list in Plesk UI: 1054 Unknown column 'rnameType' in 'field list'
- How to find a path to website's folder on the server with DB query?
- Is there are any security concern arising from using the MySQL Admin user in MySQL Workbench and website coding?
- Unable to migrate a subscription: mysqldump: Couldn't execute 'show events': Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
- How to upgrade MariaDB 10.0 to 10.1 on CentOS 7
- How to assign multiple database users to another database?
- How to see the number of subscriptions per customer via CLI on a Plesk server?
- FILE privilege checkbox is missing in database user settings
- Unable to configure PostgreSQL in Plesk Onyx on Ubuntu 18.04: The test connection to the database server has failed
- How to grant the database user access to database of the other subscription?
- Unable to add PostgreSQL 10 in Plesk: UNENCRYPTED PASSWORD is no longer supported
- Integration with MSSQL breaks in Plesk Onyx 17.8 when PCI compliance settings in use: ODBCError 08001: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SSL Security error
- Cannot start MySQL: [ERROR] InnoDB: Datafile './dbname/table_name.ibd' is corrupted. Cannot determine the space ID from the first 64 pages
- Unable to create database users if default db server is set to NONE: setMultiOptions() must be of the type array, null given
- How to rename a MySQL database on a Plesk server
- Website shows 500 internal error: User already has more than max_user_connections
- Plesk intermittent error, while accessing certain domains in Plesk: C:\Program Files (x86)\Plesk\admin\engine\php-cgi.exe - The FastCGI process exited unexpectedly
- Unable to start MySQL service: InnoDB: Waiting for the background threads to start
- MariaDB 10.3 support in Plesk
- MariaDB does not start after upgrade on Centos 7
- PostgreSQL database still exists after deleting subscription
- Backup Settings for Remote MS SQL Servers fail: Unable to connect to the network share Unable to open network connection: A specified logon session does not exist. It may already have been terminated
- A database user is not available in the Users Management menu
- Unable to export database in Plesk: Can't load module: 7z.dll
- Why despite the fact MariaDB is installed on the server in Plesk > Databases servers > MySQL is shown?
- Unable to register remote MySQL server: A connection attempt failed because the connected party did not properly respond after a period of time
- Unable to register remote MySQL server: Server sent charset unknown to the client. Please, report to the developers
- Unable to register remote MySQL server: Host is not allowed to connect to this MySQL server
- Unable to change password to database user: Can't find any matching row in the user table
- How to get a list of all active domains in Plesk?