WebScHoLaR Dot NET

The Plesk admin password can simply be reset by login to VPS using RDP with following command:

%plesk_bin%\plesksrvclient.exe

Just run the command and it will ask for new admin password. If it also shows the message that Access denied/can’t connect to MySQL then:

1. Add parameter skip_grant_tables=1 into the [PleskSQLServer] section.
2. Restart service Plesk SQL Server.

%plesk_bin%\plesksrvclient.exe -get command can be used to retrieve the Plesk admin password from the database to verify that the password has been successfully updated in Plesk system database. If Plesk admin password is not updated somehow then it can be updated manually. To do it, please, follow the steps:

1. Edit MySQL configuration file my.ini located within %plesk_dir%\mysql\data\.
2. Add parameter skip_grant_tables=1 into the [PleskSQLServer] section.
3. Restart service Plesk SQL Server.
4. Log into Plesk MySQL.

%plesk_dir%\mysql\bin\mysql.exe -P8306 mysql

1. Execute the following query:

mysql> update mysql.user set password=password(’NEWPASSWORD’) where user=’admin’;

1. Remove skip_grant_tables=1 from within the [PleskSQLServer] section within %plesk_dir%\mysql\data\my.ini
2. Restart service Plesk SQL Server.

In Windows Virtuozzo, all Windows upgrades need to be installed on Hardware Node instead of VPS. If  Windows upgrades will be installed inside VPS and those upgrades are not installed on Hardware Node, the VPS will be corrupted and it won’t start up on reboot. In thie case, all system files in system32 and system32\drivers folder need to be replaced with the system files from Hardware Node to start the VPS. These commands can be used to replace the system files inside VPS.

copy /y  C:\WINDOWS\system32  C:\vz\root\VE_ID\C\WINDOWS\system32
copy /y  C:\WINDOWS\system32\drivers  C:\vz\root\VE_ID\C\WINDOWS\system32\drivers

(NOTE: Replace System Drives and path as per the installation)

New Plesk versions 8.6+ comes with MSDE (Microsoft SQL Desktop Edition) by default so you just need to follow the below mentioned steps in order to configure it.In earlier Plesk versions, MSDE needs to be installed. This can be done by downloading the MSDE from Microsoft site or installing “msde” virtuozzo template. Virtuozzo template can be installed to VPS using VZMC or “vzpkgadd” command. Continue reading »