Prologue
First I want to mention that the original issue was password related. I kept getting wrong password error in both phpmyadmin and mysql console. I did not change the password to be clear.
Attempted solutions:
- Restarting services
- Rebooting PC
- Tried possible default passwords: root, password, 'blank', your_password
- Inserted
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
into the first line of file "my.ini", which actually came from here https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
New issue
After attempt number 4, the server now sefuses to run, wampmysql64 is stuck on starting in windows services. Rolling back the changes did not solve it.
Attempted solutions(again)
- Restarting services
- Rebooting PC
- Turning off firewall
- Port 3306 is not being used by any other service or process.
- Made sure 'skip-networking' was commented in my.ini
- Deleting auto.cnf, and ib_logfile0 and ib_logfile1
All failed. Attempts 5 and 6 came from here https://superuser.com/questions/321744/wamp-mysql-service-will-not-start
MySQL files
- inside wampmysql64 properties in services
- general tab
- startup type was set to disabled
- changing it back to manual gave error "service marked for deletion"
After a reboot
- wampmysql64 service is gone
- reinstalling it through the wamp menu>mysql>service administration
- It runs now!
Password Anomaly remains.
UPDATE 2
Password was successfully reset with this code into mysql console, I had to run the server with skip-grant-tables
uncommented(byremoving the ';') from the my.ini file.
UPDATE mysql.user
SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N'
WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;
Reboot, Restart all servives, bingo, connected and password is working. Wait what?......Databases are gone.
root
or a differenct password onroot
Did you install something that may fit this bill??