Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Plesk for Windows is not accessible: No connection could be made because the target machine actively refused it
- Unable to login to Plesk after MySQL upgrade: unknown variable 'innodb_additional_mem_pool_size='
- 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?
- 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
- Unable to add the database for a domain: Unable to find row with id NaN in DatabaseServers table
- How to change the innodb_log_file_size value in MySQL/MariaDB
- Plesk is inaccessible and it is not possible to start MySQL/MariaDB: MySQL system database not found in /var/lib/mysql
- Attempt to connect or drop psa database hangs
- How to provide CREATE ROLE permission for MSSQL database users
- [BUG] Unable to add PostgreSQL server to Plesk: A database server with this combination of host address and port number is already registered
- [BUG] Copy database not working: no errors are shown in Plesk GUI
- Website using MSSQL is inaccessible: SqlException (0x80131904): The SELECT permission was denied on the object
- Database import fails: There can be only one TIMESTAMP column
- Unable to restore database backup InnoDB: Error: Table "mysql"."innodb_table_stats"
- Is it possible to downgrade MySQL/MariaDB on Plesk server?
- Failed to login to the client's MySQL using Plesk admin credentials
- Failed to access MySQL via SSH using root account
- Cannot export database dump from Plesk: The user name or password is incorrect (Error code 21)
- Is it possible to add MS SQL server in Plesk based on Linux system?
- Exporting database dump in phpMyAdmin on Plesk server fails: Your export is incomplete, due to a low execution time limit at the PHP level
- A MySQL query executed in phpMyAdmin/PHP script fails when the ONLY_FULL_GROUP_BY SQL mode is configured
- Cannot restart MySQL service from Plesk administrator panel on Linux
- How to create a database dump using PHPMyAdmin in Plesk?
- How to change default MySQL directory %plesk_dir%\Databases\MySQL\data to another one?
- Error in Plesk: SQLSTAT[HY]: General Error: Got Error 122 "internal (unspecified) error in handler" from storage engine