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"
You should follow me on twitter here or grab rss feed to keep track of new changes.
Featured Articles:
- 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
- Top 30 Nmap Command Examples For Sys/Network Admins
- 25 PHP Security Best Practices For Sys Admins
- 20 Linux System Monitoring Tools Every SysAdmin Should Know
- 20 Linux Server Hardening Security Tips
- Linux: 20 Iptables Examples For New SysAdmins
- Top 20 OpenSSH Server Best Security Practices
- Top 20 Nginx WebServer Best Security Practices
- 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
- 15 Greatest Open Source Terminal Applications Of 2012
- My 10 UNIX Command Line Mistakes
- Top 10 Open Source Web-Based Project Management Software
- Top 5 Email Client For Linux, Mac OS X, and Windows Users
- The Novice Guide To Buying A Linux Laptop
{ 5 comments… read them below or add one }
but if I lost mysql pw..how can I run that command?
^ Very good point.
I just get an error “‘MySQL.exe’ is an unrecognised command” etc
@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.
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.
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