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

Jcats

Well-Known Member
PartnerNOC
May 25, 2011
806
156
168
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 [email protected]'localhost' identified by '$LEECHPASS';" ; mysql -u leechprotect -p"$LEECHPASS"
You should end up with MySQL prompt:

Code:
mysql>
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
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.
 

hbouma

Well-Known Member
Jun 8, 2002
60
0
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