Results 1 to 7 of 7

Thread: Changing a password

  1. #1
    marksalehouse is offline Senior Member
    Join Date
    Jul 2007
    Posts
    119
    WHB Points this Month
    0.00
    WHB Points
    30.00
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Changing a password

    I would like to log on to my Cpanel and change the password - which appears to also change the MYSQL DB passwords as well. However, I get the following error when I try to log on to my

    General Error
    SQL ERROR [ mysql4 ]

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

    An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

    It is fine once I reset to the old password.
    Is there something else I should be doing?

    Also, will this automatically change the mail passwords (Squirrel etc.)?

    Mark

  2. #2
    Vladimir B.'s Avatar
    Vladimir B. is offline Administrator
    Join Date
    Jun 2007
    Posts
    103
    Servers
    WTF?!
    WHB Points this Month
    0.00
    WHB Points
    5.00
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default

    Mark,

    Also, will this automatically change the mail passwords (Squirrel etc.)?
    No, it won't.

    When you changed your cPanel account password, cPanel changed 3 account passwords automatically :
    1. Your system account password on the server which is used to login to cPanel or WHM interface.
    2. Your main FTP account password which has the same login as your cPanel account.
    3. Your main MySQL user password which is used to login to phpMyAdmin.

    Please take into account that you should never use this main MySQL user for your MySQL databases due to security reasons.
    Also I recommend to create independent MySQL users for each MySQL database.
    You can easily do this in your cPanel using "MySQL Databases" menu.

    As far as I understand, you are not able to login to some installed software now as it is using your main MySQL user. Just login to your cPanel account, create a new MySQL user, add it to the needed MySQL database and correct the needed settings in your software configuration file.

    If you have any problems doing this on your own, please create a ticket in Technical Department at https://www.whbsupport.com/
    ---
    Regards,
    Vladimir B.
    Senior System Administrator
    WebHostingBuzz USA LLC
    Help WebHostingBuzz today. Like us on Facebook, follow us on Twitter or Google +1 us.
    Visit www.webhostingbuzz.com and look for the social media icons at the top of the page.

  3. #3
    marksalehouse is offline Senior Member
    Join Date
    Jul 2007
    Posts
    119
    WHB Points this Month
    0.00
    WHB Points
    30.00
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks for that. Can you explain this bit for me please?

    correct the needed settings in your software configuration file.

    Mark

  4. #4
    Maxim M.'s Avatar
    Maxim M. is offline WeeHBie
    Join Date
    Sep 2008
    Location
    Kharkiv, UA
    Posts
    564
    Servers
    webhostingbuzz.com
    WHB Points this Month
    0.00
    WHB Points
    65.00
    Thanks
    16
    Thanked 4 Times in 4 Posts

    Default

    Normally configuration file includes the database name, database user and password. It may depend on the type of script/software you use.

    If you are not sure how to update that file, feel free to open a support ticket and our techs will advise.
    Maxim M.
    Product Manager
    WebHostingBuzz.com

    Join our FaceBook community for the useful info and latest promotions.

  5. #5
    marksalehouse is offline Senior Member
    Join Date
    Jul 2007
    Posts
    119
    WHB Points this Month
    0.00
    WHB Points
    30.00
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Thanks guys, but it turned out to be very simple:

    Change the password in the Cpanel.
    Download the BB Forum file "config.php"
    Amend the password on the line: "$dbpasswd = 'xxxxxxxxxx';": save.

    I found it here:
    phpBB • View topic - Trying to change the database password - help?

    I can now access the Cpanel and the PHPBB Forum.

    I also had to change a couple of other items as well:

    Coppermine Gallery:
    Modify include/config.inc.php

    Calender:
    Change password within the file "config.php

    Thanks for the help.

    Mark

    PS:
    This could be closed.
    Last edited by marksalehouse; 03-15-2012 at 02:23 PM.

  6. #6
    Join Date
    Apr 2017
    Posts
    10
    WHB Points this Month
    0.00
    WHB Points
    0.00
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Unfortunately, I can not help you! I'm not good at this. Sorry!((

  7. #7
    marksalehouse is offline Senior Member
    Join Date
    Jul 2007
    Posts
    119
    WHB Points this Month
    0.00
    WHB Points
    30.00
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    This thread is five years old.
    It has been solved.

    Why are you answering a thread that is so old and resolved? Especially when you cannot give a resolution?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •