Messages

If you reset FTP password but still unable to login into your FTP account with new password, follow below commands to get the password stored on the server for your FTP account.

Open command prompt and enter below commands to get the password of any FTP account.

cd %plesk_bin%

dbclient.exe --direct-sql --sql="select * from sys_users where login='FTP_account_name'";

It will show below details for your FTP user.

id      login   account_id      home    shell   quota
1      abc      638              c:\path  no      1024

Now take account_id from above output and use it under below command to get the password. (638 is the account ID from the dbclient command we use earler)

dbclient.exe --direct-sql --sql="select * from accounts where id=638";

Hello,

If you face the following error in cpanel for email trace, follow below steps to resolve the problem.

could not connect to mysql access denied for user 'eximstats'@'localhost' (using password yes)

Follow the below steps to resolve this error.

Try resetting eximstats password with below command.

/usr/local/cpanel/bin/generate_eximstats_pass

It will reset and display new password for eximstats. Just in case you did not see new password you may get it with below command.

/usr/local/cpanel/bin/eximstatspass

It should resolve the error. If you still face the same error, reset the password manually from mysql with below steps.

First login into mysql with root privileges, after that run below commands.

(XXXXXXXXX) is the password you get with "/usr/local/cpanel/bin/eximstatspass"

mysql > update mysql.user set password=password("XXXXXXXXX") where user="eximstats";
mysql> flush privileges;
msyql> quit   

You face such problem after upgrading your wordpress or installing a new theme, all pages of your wordpress start showing blank page and there is no other way to access your wp-admin panel to change or manage the theme you installed.

You can resolve it by renaming the currently installed theme from FTP, which will force wordpress to reset your blog to default theme. By doing this you will be able to access your wp-admin panel to edit / change your theme.

Navigate to wp-contents/themes directory via FTP and rename the theme you installed or the active theme due to which your blog start showing blank page. For example "twentythirteen" to "twentythirteen-bk".