Databases

Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.

Attempted MariaDB database server upgrade results in Plesk GUI inaccessibility: DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Unable to reset password for 'sa' user on Plesk server
On Plesk the MariaDB service goes down intermittently: './database_name/table_name' is marked as crashed and should be repaired
WordPress site does not work: Error establishing a database connection
FATAL: Peer authentication failed for user "admin"
The same database is opened each time when accessing different databases via phpMyAdmin in Plesk
How to export a website database in Plesk?
How to upgrade MariaDB on Plesk for Linux
How to add db_owner role to newly created users
How to create a database dump using PHPMyAdmin in Plesk?
Unable to import MySQL/MariaDB database from .tmp file in Plesk: ERROR: ASCII '\0' appeared in the statement
"Import Dump" and "Export Dump" buttons are not shown in Plesk
Plesk upgrade or databases backup fails: mysqldump: unknown variable
How to fix InnoDB corruption cases for the MySQL/MariaDB databases on Plesk for Windows?
MariaDB logrotate on Plesk server reports error: logrotate_script: 3: [: /var/run/mysqld/mysqld.pid: unexpected operator
How to increase upload dump size for phpMyAdmin in Plesk?
Which MariaDB versions are supported by Plesk?
MySQL/MariaDB error on the server with Plesk: Could not increase number of max_open_files to more than 16384
Remote connection to a database hosted on Plesk fails: ERROR 2003 (HY000): Can't connect to MySQL server
Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools
How to restore all MySQL / MariaDB user databases from a Plesk backup
Cannot restore domain in Plesk: Failed to restore the remote database for security reasons
Cannot remove MySQL database: There is no such grant defined for user on host
Unable to import a database dump: Cannot add or update a child row: a foreign key constraint fails
How to get a list of all databases/database tables and their size via a command-line interface on a Plesk server
Unable to add a database on a Plesk subscription: There are no database servers available for this subscription
Website hosted on Plesk is not working: Microsoft OLE DB Provider for SQL Server error '80004005'
How to back up / restore a system database in Plesk
How to enable remote access to MySQL/MariaDB server in Plesk?
Warning on the "Database Servers" page in Plesk: Unable to determine the TCP port number used by Microsoft SQL server