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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

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

Tags:
  1. SSy

    SSy Member

    Joined:
    May 10, 2016
    Messages:
    24
    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:
    599
    Likes Received:
    92
    Trophy Points:
    153
    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>
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    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.
     
  4. hbouma

    hbouma Well-Known Member

    Joined:
    Jun 8, 2002
    Messages:
    54
    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