Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Access denied for user 'leechprotect'@'localhost' (using password: YES)

Discussion in 'General Discussion' started by SSy, Feb 21, 2017.

Tags:
  1. SSy

    SSy Active Member

    Joined:
    May 10, 2016
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi there - how do I set the correct password for this service? Thanks.
     
  2. Jcats

    Jcats Well-Known Member

    Joined:
    May 25, 2011
    Messages:
    718
    Likes Received:
    122
    Trophy Points:
    168
    Location:
    New Jersey
    cPanel Access Level:
    DataCenter Provider
    Try this:

    Code:
    # LEECHPASS=$(/usr/local/cpanel/bin/leechprotectpass) ; /usr/bin/mysql -e "grant all privileges on leechprotect.* to leechprotect@'localhost' identified by '$LEECHPASS';" ; mysql -u leechprotect -p"$LEECHPASS"
    You should end up with MySQL prompt:

    Code:
    mysql>
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you verify where you are receiving this error message? Also, what version of cPanel is installed on this system?

    In cPanel 62, we updated the leechprotect service to use SQLite. This change eliminates the need for a MySQL database and database user to run the leechprotect service.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. hbouma

    hbouma Well-Known Member

    Joined:
    Jun 8, 2002
    Messages:
    58
    Likes Received:
    0
    Trophy Points:
    306
    Lol, just a heads up Michael. You guys are being pretty sloppy with your conversions from using MySQL to SQLite because you're still leaving the users in the MySQL database. It then becomes very confusing then when we're trying to upgrade MySQL on older systems and we're being told that the passwords for cphulkd roundcube leechprotect and eximstats are still using the old password format and need to be updated prior to upgrading. However, if roundcube, leechprotect, and eximstats are now no longer using MySQL, then why are those users still there? Had your conversion scripts properly cleaned up after itself, it wouldn't look like we needed to fix their passwords prior to upgrading the databases. That would also save us a lot of time and frustration because resetting all these passwords (especially for cphulk) isn't very well documented. Like I came here looking to reset the leechprotect password, only to realize nearly all of these weren't necessary anymore.

    Hal
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice