Made mistake while resetting admin password, now can’t login
Posted by: (
Date: July 08, 2019 03:59PM

I am really in a pickle.

I am using WordPress on WAMPserver and have quite a lot of data there.

Everything was working fine, then I tried to reset the admin password from the database.

I changed the password in MySQL command line first. It was successful, then I changed it again and I think I made a typo in the username/password. Then, changed the corresponding values in

– When I open MySQL cmd line, it asks for a password, I’ve tried all the possible passwords, nothing works. As soon as I enter something for the password, the cmd line shuts down.
– Cannot log into MyPHP admin, the username/password is incorrect.
Tried to keep the value for ‘AllowNoPassword’ = true. This too did not work.
– CError in wp-admin: Error connecting to Database (MySQL).

Please help!

Options: ReplyQuote
Re: Made mistake while resetting admin password, now can’t login
Posted by: RiggsFolly (Moderator)
Date: July 08, 2019 04:31PM


Take a look at this answer On Stackoverflow

(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote

Sorry, only registered users may post in this forum.