Upgrade failed with error: Access denied for user 'sitebuilder_db'@'localhost' (using password: YES)

Refers to:

  • Web Presence Builder 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Created:

2016-11-16 13:10:02 UTC

Modified:

2016-12-21 20:05:59 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Upgrade failed with error: Access denied for user 'sitebuilder_db'@'localhost' (using password: YES)

Symptoms

Upgrade of Plesk is failing with below error:

[ERROR]Unable to connect to database. System message: SQLSTATE[HY000] [1045] Access denied for user 'sitebuilder_db'@'localhost' (using password: YES)
There were some configuration errors, check logs
Logs saved to %plesk_dir%\\sb/tmp/sb_config-1407031331.log

Failed to install 'C:\\parallels\\SITEBUILDER-WIN_12.0.5\\dist-msi-Microsoft-2003-i386\\sitebuilder-core.msi': Fatal error during installation. (Error code 1603)

ERROR: The installation of the package 'sitebuilder-core' failed with code 1603. (upgrade: upgrading Parallels Presence Builder Core...)
Not all packages were installed.
Please, contact product technical support.

Cause

Sitebuilder database and user is missing in MySQL

Resolution

  1. Find the sitebuilder_db user credentials in the Parallels Presence Builder configuration file, %plesk_dir%\sb\config :

    host = localhost     
    username = sitebuilder_db
    password = 123123123
    port = 3306
    dbname = sitebuilder5
  2. Add string to MySQLD section in %plesk_dir%\Databases\MySQL\data\my.ini :

    skip-grant-tables
  3. Restart MySQL Service .

  4. Log in to the MySQL Server :

    > "%plesk_dir%\\MySQL\\bin\\mysql.exe" mysql
  5. Update the sitebuilder_db user's password replacing in the first command with the password found in step #1

    mysql> update mysql.user set password=password("<PASSWORD>") where user='sitebuilder_db';
  6. Remove skip-grant-tables string added in step 2 and restart MySQL Service .

  7. Continue the upgrade using installer with executable parameter --console

Note: If you don't have any websites created with sitebuilder or data stored in sitebuilder5 database, you can remove it's component by executing ..\SITEBUILDER-WIN_12.0.6\dist-msi-Microsoft-2003-i386\sitebuilder-core.exe

Have more questions? Submit a request
Please sign in to leave a comment.