Quote From : tidus May 30, 2014, 6:56 am
Since you can get into mysql terminal just by pressing enter means the password is blank. Ampps comes with default password as "mysql". So it has been changed, may be the third party tool might have changed it.
The 3rd party app was installed after the password fail and accessed mysql without entering a password. The password has never been changed.
Quote
So to fix the issue, set the password as mysql:
Code C:\Ampps\mysql\bin\mysqladmin.exe -u root password mysql
If you are changing it to anything else other than "mysql", then change the contents of the file C:\Ampps\ampps\data\my.conf with the same password.
To go back to the beginning: my.conf contains the original value "mysql".
Login fails using password 'mysql' but works with no password Code
C:\Ampps\mysql\bin>mysql.exe -u root -pmysql
Warning: Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
C:\Ampps\mysql\bin>mysql.exe -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Trying to set the password to 'mysql' fails: Code
C:\Ampps\mysql\bin>mysqladmin.exe -u root password mysql
mysqladmin.exe: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
Quote
Close Ampps and start it again as Administrator. Right click -> Run as Administrator.
As admin:
Code
Amupdate.exe - System Error
The program can't start because QtCored4.dll is missing from your computer. Try reinstalling the program to fix this problem.
Can't access myPHPadmin. Can't set password. Can't upgrade. Dead end?
|