Category:

Edit the file for the PSA MySQL instance:
C:Program FilesSWsoftPleskMySQLDatamy.ini

Add the following line to the top of the MySQLD section:
skip-grant-tables
Restart the MYSQL and PLESK SQL services.
Login at:
cd C:Program FilesSWsoftPleskMySQLbin

mysql.exe -uadmin -P8306
use psa;
Select * from domains where name = “thedomainname.com”;
Get the ID# listed in the first column, this is the dom_id#

Select * from siteapps where dom_id = “dom_id#”;
Get the id# of all apps in the first column

delete quick from siteapps where id = “x” and dom_id = “y”;

x = id related to the siteapplication vault (siteapppackages table) y = domain id of the client ( hosting table)

Remove the “skip-grant-tables” from my.ini and then restart the MYSQL and PLESK SQL services again.

If you receive error about ftpmanager not being able to remove user, check under the domain for what user is associated with the domain. It has probably been deleted. If so just recreate it and the iusr, then go to properties > profile, then set the home directory to the directory of the domain. The directory of the domain probably got deleted as well, just recreate.

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.