Howto reset Admin account locked out of Plesk Control Panel

last updated in Categories , , , , , ,

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, DevOps engineer, and a trainer for the Linux operating system/Unix shell scripting. Get the latest tutorials on SysAdmin, Linux/Unix and open source topics via RSS/XML feed or weekly email newsletter.

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

    Still, have a question? Get help on our forum!