Can anyone help put an end to my agony?? I have been trying for over four hours yesterday to get past this 1045 MySQl error after a fresh WAMPS2 install on windows XP. The previous install was the same versions just all individual stand alone instances of Apache 2.28, PHP 5. and MySQL 5 I checked both sites for help but there is little or no help to be found that directly applies to this, because they all want me to set a new password in PHP my admin which of course won't run unless it can verify user and password, I have not changed the defaults, so root SHOULD work, but doesn't. I tried the MySQL tool to configure current instance but also cannot get past the same error while using root as original password, I also tried a variety of other attempts from command line, but again need a valid password, as well as the MySQL administrator in GUI tools, but no user or previous connection will allow access! Can ANYONE help with this? Thanks in advance, TSG!
Yes I know that is what the error is but WHY? am I getting it with all defaults left as is? In other words I cannot access the MySQL server instance with out a password, and cannot set a password with out accessing the server instance! Thank you, TSG!
if that fails, you should be able to start mysql in safe mode, which allows changing the root password. safe_mysqld --skip-grant-tables& at which point you should be able to update the root password. Couple of things to try. 1. Dont be offended - it happens - make sure mysql service is running - start>run>taskmgr if necessary 2. If you have setup phpmyadmin yourself, using the setup script. bare in mind that the setup script will not work until you copy the config file, from the config directory into the phpmyadmin root directory.
Just stopped in to thank you for the input, but been otherwise buried and havn't gotten back to it, I'll let youknow how I make out when I do! TSG!
Okay based on your input I followed the instructions and ran in to a roadblock formed by a missing .cnf file, haven't the slightest idea why this was so, since I deleted no files except for the previous instances I removed before the install on a different drive, so since I remembered that the previous install retained the path to the original file set, and didn't alter anything except for the new files in the new dir's on a different drive, I went and ran the install again, which apparently only updates what's not there but doesn't alter the remaining set up files and such, because I had already migrated my remote server sites down in to the local and didn't want to do that again. bottom line is I recovered the missing file, and reset everything to defaults, and was able to access every aspect of the WAMPS2 programs and environments, as well as PHP my Admin and MySQL server! Thanks for leading me down the path! TSG!