Databases
Articles related to MS SQL, MySQL, PostgreSQL and other database servers including webadmin applications.
- Unable to access Plesk or execute Plesk CLI utilities: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[42000]: Syntax error or access violation: 1064 <...> near '' at line 1, query was: SET sql_mode = ''
- Unable to clone the database in Plesk: Error: Unable to copy the database
- How to disable single user mode in MSSQL?
- Is it possible to install MariaDB server alongside MySQL?
- How to set query_cache_size for MySQL in Plesk?
- Is it possible to add an external Postgre SQL server in Plesk for Windows?
- Is it possible to limit number of databases by database type in Service Plan?
- Add Database button is missing in the Customer Panel
- Create new database failed: mssqlmng failed: The file "mdf" is compressed but does not reside in a read-only database or filegroup
- How to hide databases in phpMyAdmin
- Does Plesk support MySQL 5.6 on CentOS 7 out of the box?
- Unable to import/export database through Plesk: Internal error: [Account :: getPassword] can not decrypt password to be plain
- How to change a default MySQL/MSSQL database server for a subscription
- Website is not working: connect() timed out!
- Sites show: Error establishing a database connection
- How to change shell option (SSH access) for all domains on a server using CLI?
- How to list databases with their subscription/domain/owner using MySQL queries
- phpMyAdmin large table loads slow
- Why the size of database from Statistics does not match with the size from Database tab?
- How to set password for database user in Plesk
- Site is not available: Table doesn't exist
- Is it possible to use MySQL on loopback interface only?
- Database export stuck on "Preparing for exporting"
- Accessing users from Email Address tab fails with the error: Access denied
- How to view the version of MySQL in Plesk for Windows
- Does Plesk support MySQL failover cluster?
- Is Microsoft SQL Server 2017 compatible with Plesk for Windows?
- Unable to login to MySQL: Access denied for user 'admin'@'127.0.0.1' (using password: YES)
- How will backup be performed for a database that is used for several WordPress instances
- How to get a list of subscriptions and their IP addresses