Prologue
First, I want to mention that the original problem is with the password. I was still getting the wrong password error in both phpmyadmin and the mysql console. I have not changed the password to be clear.
Attempts to solve:
New problem
After trying number 4, the server now shuts down to start, wampmysql64 gets stuck at startup in Windows Services. Rollback changes did not allow it.
Attempts to solve (again)
- Service restart
- PC reboot
- Disabling Firewall
- Port 3306 is not used by any other service or process.
- Make sure "skip-networking" is commented out in my.ini
- Removing 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
my.ini
mysql.log
UPDATE
- wampmysql64 properties in services
- sharing tab
- Startup type has been disabled.
- changing it in manual mode gave the error "service marked for deletion"
After reboot
- wampmysql64
- wamp > mysql >
- !
.
2
reset mysql, skip-grant-tables uncommented ( ';') my.ini.
UPDATE mysql.user
SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N'
WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;
, , , . , ?...... .