Howto reset Admin account locked out of Plesk Control Panel

by on February 8, 2007 · 5 comments· LAST UPDATED February 8, 2007

in , ,

Q. My admin user account locked due to multiple failed logins. How do I reset Admin account which is in locked status under Plesk Control Panel?

A. The Plesk software package is a commercial web hosting automation solution by SWsoft. It is comprehensive server management software that manages all systems and applications for Web-Hosting on a single server.

For your safety Plesk lock out admin account after multiple failed logins. There are two ways to fix this problem.

If you are using Linux/UNIX server

a) Wait for 30-45 minutes and your admin account will be automatically reset.

b) If you can not wait for 30 minutes simply login over ssh and type the following command to reset plesk admin
# mysql -u admin -p psa
You need to provide current admin password.
At mysql prompt type the command:
mysql> delete from lockout where login = 'admin';

If you are using Windows Server type the following command:

a) Connect using terminal server or VNC

b) Click on Start > Run and type the command cmd > Press [Enter] key

c) At a command prompt type the command:
C:>\Program Files\SWsoft\Plesk\MySQL\bin\mysql.exe -u admin –p PASSWORD -P8306 -D psa -e "DELETE FROM lockout"

TwitterFacebookGoogle+PDF versionFound an error/typo on this page? Help us!

{ 5 comments… read them below or add one }

1 tarot readers November 18, 2008 at 5:10 am

but if I lost mysql pw..how can I run that command?

Reply

2 Abe January 15, 2009 at 11:45 am

^ Very good point.

I just get an error “‘MySQL.exe’ is an unrecognised command” etc

Reply

3 Philip Sturgeon January 30, 2009 at 9:21 am

@tarot readers: This is not to help you reset your MySQL password. If Plesk has given you a temporary lockout due to entering an incorrect password 3 times, it will put an entry in the lockout MySQL table. This simply removes that entry.

@Abe: Are you sure you have MySQL.exe in that exact location on your Windows server? These instructions are meant as guidelines not exact copy and paste. Vivek Gite obviously has no idea where every MySQL installation is located.

Reply

4 Philip Sturgeon January 30, 2009 at 9:23 am

Forgot to mention, this works perfectly. I tried a few other similar commands but all suggested I put the password in after -p which although matches what the manual says, was not working for me at all.

I’d put the password in the command, then it would ask for it again and report “Database ‘password’ does not exist.”. Got it working now anyway, so thanks again.

Reply

5 Doug Griffin November 8, 2010 at 11:26 pm

Awesome! I used this on my virtual server. When I mistyped in mySQL I got a funny -> prompt. exit; \c \c; did not help. Only cntrl-C did the trick. However cntrl-C negated my sql delete statement. I also had to hunt around for the exit; command. All of the above, however, were very minor. I was thrilled to fix this on my own, without a call to Godaddy

Reply

Leave a Comment

Tagged as:

Previous Faq:

Next Faq: