Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Upgrade of MySQL schema with mysql_upgrade fails with the error: Error: Incorrect database name '#mysql50#.ssh'
- How to change the max_user_connections value in MySQL/MariaDB on a Plesk server
- How to register an existing database in Plesk
- Unable to remove a database marked as "Used by an installed web app" in Plesk
- 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
- How to change the innodb_log_file_size value in MySQL/MariaDB
- Attempt to connect or drop psa database hangs: Native table 'performance_schema'.'session_variables' has the wrong structure
- How to provide CREATE ROLE permission for MSSQL database users
- Unable to add PostgreSQL server to Plesk: A database server with this combination of host address and port number is already registered
- 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"
- Failed to login to the client's MySQL using Plesk admin credentials
- Is it possible to add MS SQL server in Plesk based on Linux system?
- 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?
- How to add a new instance of existing MS SQL database server to Plesk
- Plesk and websites are not accessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
- How to add an already installed Microsoft SQL server in Plesk
- How to add an additional local MySQL server in Plesk on Windows?
- Cannot restore database on Plesk server: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
- MySQL service fails to start on Plesk server or other operations fail due to corrupted database
- The error in Plesk: ERR [panel] SQLSTATE[HY000] [2002] No such file or directory, Can't connect to local MySQL server through socket
- Plesk inaccessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused
- MySQL database import in Plesk fails: ERROR 1118 (42000): Row size too large
- How to add db_owner role to newly created users