Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

RoundCube webmail is not accessible on Plesk: DATABASE ERROR: CONNECTION FAILED

 
backupdatabasegoguidehosting

Symptoms

  • RoundCube webmail page is not accessible. The following error message is displayed:

    DATABASE ERROR: CONNECTION FAILED
    DB Error: SQLSTATE[28000] [1045] Access denied for user 'roundcube'@'localhost' (using password: YES) (GET /roundcube/index.php)


    DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server administrator.

Cause

MySQL roundcube user is either absent or has an invalid password or has not sufficient permissions.

Resolution

Using Plesk interface

  1. Log into Plesk.

  2. Go to Tools & Settings > Updates.

    000027.JPG

  3. Remove the component Roundcube and then install it again.

    000028.JPG


    000026.JPG

Using SSH connection

Note: The solution may be a bit complex. Contact server's administrator or hosting support if required.

  1. Connect to the server via SSH.

  2. Create Plesk database backup, for example:

    # plesk db dump > backup.sql

  3. Depending on the RoundCube version, check the database password in /usr/share/psa-roundcube/config/config.inc.php or /usr/share/psa-roundcube/config/db.inc.php:

    # cat /usr/share/psa-roundcube/config/config.inc.php
    $config['db_dsnw'] = 'mysqli://roundcube:password@localhost/roundcubemail';

  4. Copy the password;

  5. Enter Plesk database:

    # plesk db

  6. Make sure that 'roundcubemail' database exists:

    mysql> show databases like "%roundcube%";
    +------------------------+
    | Database (%roundcube%) |
    +------------------------+
    | roundcubemail |
    +------------------------+
    1 row in set (0.00 sec)

    If the database is missing, go back to the first solution via Plesk user interface and reinstall (remove/install) RoundCube component. If the database is present continue this guide.

  7. Check whether the roundcube user is present. Empty output means that the user is absent:

    mysql> use mysql;
    mysql> select * from user where user='roundcube';

  8. Create user and assign a password:

    Note: If the user exists already, it is only needed to generate the password. There is no need for the CREATE USER sentence

    For MySQL 5.0/5.1/5.5/5.6 and MariaDB 10.1

    mysql> CREATE USER 'roundcube'@'localhost';
    mysql> update user set password=password('<password_from_config.inc.php>') where user ='roundcube';

    For MySQL 5.7

    mysql> CREATE USER 'roundcube'@'localhost';
    mysql> SET PASSWORD FOR 'roundcube'@'localhost' = '<password_from_config.inc.php>';

    For MariaDB 10.5+

    MariaDB [mysql]> CREATE USER 'roundcube'@'localhost';
    MariaDB [mysql]> SET PASSWORD FOR 'roundcube'@'localhost' = PASSWORD('<password_from_config.inc.php>');

  9. Grant the necessary privileges:

    mysql> GRANT USAGE ON roundcubemail.* TO 'roundcube'@'localhost';
    mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON roundcubemail.* TO 'roundcube'@'localhost';
    mysql> flush privileges;

    Note: if "Can't find any matching row in the user table" error appears when running Grant command, use command without the host:

    mysql> GRANT USAGE ON roundcubemail.* TO 'roundcube';
    mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON roundcubemail.* TO 'roundcube';
    mysql> flush privileges;

Tweet
Share
Share
Email
0 Shares
Read the full article
Related Posts

Securing the WordPress Frontier with WP Guardian

Read More »

Introducing WP Guardian Vulnerability Protection: Now available for WP Toolkit

Read More »

How to Host a Go App on Plesk

Read More »
Knowledge Base

 An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘X’ for key ‘PRIMARY’

Read More »

How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux

Read More »

Different operations on Plesk for Linux server fail: /usr/sbin/usermod execution failed: usermod: user is currently used by process

Read More »

Unable to install WordPress using Plesk WordPress Toolkit on CloudLinux : Call to undefined function json_encode()

Read More »

Hosting Wiki

  • Django
  • DBMS Interface
  • Server Redundancy
  • RoundCube
  • QMAIL
  • Sendmail
  • Google Cloud CDN
  • Bare Metal Server
  • Backup
  • MySQL
  • PhpMyAdmin
  • phpPgAdmin
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • Linux
  • PHP
  • MongoDB
  • SQL
  • Hosting Control Panel
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • SSH
  • Colocation Hosting
  • Reseller Hosting
  • Cloud Hosting
  • VPS Hosting
  • Dedicated Hosting
  • Shared Hosting
  • Free Hosting
  • Managed Hosting
  • Email Autoresponder
  • Mailing Lists
  • Email Alias
  • Email Virus Protection
  • Email Forwarding
  • Webmail
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family