Article ID: 116833, created on Aug 20, 2013, last review on Aug 25, 2016

  • Applies to:
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux


During a Plesk upgrade the following error appears in the /tmp/plesk_11.5.30_repair.log log:

ERROR 1045 (28000): Access denied for user 'pp_sb_db'@'localhost' (using password: YES)


On attempt to get access to Presence Builder in Plesk GUI, the following error is displayed:

Internal error: SQLSTATE[HY000] [1045] Access denied for user 'pp_sb_db'@'localhost' (using password:  <Password has been wiped out for security reasons>

File Generic.php
Line 33
Type SB_Facade_Exception_Generic


  1. Find the pp_sb_db user credentials in the Presence Builder configuration file, /usr/local/sb/config:

    host = localhost
    username = pp_sb_db
    password = 123123123
    port = 3306
    dbname = sitebuilder5
  2. Log in to the MySQL server as the administrator:

    #MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin  mysql
  3. Update the pp_sb_db user's password and privileges using the following commands, replacing <PASSWORD> in the first command with the password found in step #1:

    GRANT USAGE ON *.* TO 'pp_sb_db'@'localhost' IDENTIFIED BY '<PASSWORD>';
    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `sitebuilder5`.* TO 'pp_sb_db'@'localhost';
    INSERT INTO mysql.tables_priv (Host,Db,User,Table_name,Table_priv,Column_priv) VALUES ('localhost','sitebuilder5','pp_sb_db','%','Select,Insert,Update,Delete,Alter','Select,Insert,Update');

In case if the error appears during an upgrade, follow step below.

  1. Continue the upgrade using the script:

    # /usr/local/psa/bootstrapper/pp11.5.30-bootstrapper/ repair

Search Words

Return code of sitebuilder bru utility

update to v12

login fails

SQLSTATE[28000] [1045] Access denied for user 'pp_sb_db'@'localhost' (using password: YES)

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)


sw-engine doesn't start

ERROR 1045 (28000): Access denied for user 'pp_sb_db'@'localhost' (using password: YES)

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a

Email subscription for changes to this article
Save as PDF