Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Plesk and system update fails: http://yum.mariadb.org/10.1/centos7-amd64/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found
- How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?
- How to fix InnoDB corruption cases for the MySQL databases on Plesk for Linux?
- Unable to start MariaDB 10.6 on a Plesk server: Bind on TCP/IP port. Got error: 22: Invalid argument
- Plesk database servers menu shows warning: Unable to determine the TCP port number used by Microsoft SQL server 'localhost'
- MySQL package fails to update on Plesk server: The GPG keys listed for the "MySQL 5.7 Community Server" repository are already installed but they are not correct for this package.
- In Plesk, dumps of MySQL databases with DEFINERs/TRIGGERs are exported with incorrect syntax of queries that should create DEFINERs/TRIGGERs
- Unable to repair domains in Plesk using "plesk repair db" utility: The following domains are assigned to already removed IP addresses
- Unable to restore the Plesk psa database: ERROR 1813 (HY000) at line 104: Tablespace for table '`psa`.`tablename`' exists. Please DISCARD the tablespace before IMPORT
- Unable to add MS SQL Server in Plesk: Login failed for user 'administrator'
- Error in Diagnose & Repair tool: The following domains are assigned to already removed IP addresses. Reassign the domains to existing IP addresses
- Unable to delete MS SQL database in Plesk: User does not have permission to alter database, the database does not exist, or the database is not in a state that allows access checks
- Unable to remove a MSSQL from Plesk: Login 'jdoe' owns one or more database(s). Change the owner of the database(s) before dropping the login.
- Unable to export MySQL dump for a domain in Plesk: insufficient privileges to SHOW CREATE
- Unable to access Plesk with 500 error message: [2002] No such file or directory
- A PHP-based website on Plesk server fails to open: Failed to connect to MySQL: Access denied for user 'jdoe'@'localhost' (using password: YES)
- MySQL service fails to start on a Plesk server: Table 'mysql.user' doesn't exist
- Unable to add external database server in Plesk: 1044 Access denied for user
- How to restore Plesk system databases from a Plesk daily/pre-upgrade dump
- Restoration of a database fails in Plesk: errno: 140 "Wrong create options"
- Unable to create a database in Plesk: A database with the name example_db already exists
- How to switch database server from MySQL to MariaDB on Plesk Obsidian for Windows
- Is it possible to install PostgreSQL 10.x on CentOS 7 with Plesk?
- Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools
- Backup failed with the error in Plesk: 1049 Unknown database 'example'
- Remote connection to MySQL database hosted on Plesk fails: ERROR 2003 (HY000): Can't connect to MySQL server
- MySQL error on the server with Plesk: Could not increase number of max_open_files to more than 16384
- Domains show Plesk default page: web service cannot operate: the IP address list with ID 101 is empty
- Cannot import database dump in Plesk: Index column size too large. The maximum column size is 767 bytes
- InnoDB corruption occurs in MariaDB on Plesk server after reboot: Unspecified GSS failure