Howto reset Admin account locked out of Plesk Control Panel

in Categories , , , , , , last updated February 8, 2007

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"

Posted by: Vivek Gite

The author is the creator of nixCraft and a seasoned sysadmin and a trainer for the Linux operating system/Unix shell scripting. He has worked with global clients and in various industries, including IT, education, defense and space research, and the nonprofit sector. Follow him on Twitter, Facebook, Google+.

Share this on (or read 5 comments/add one below):

5 comment

  1. @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.

  2. 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.

  3. 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

    Have a question? Post it on our forum!