Ok all, I FIXED IT!

After a LONG battle with this issue, I finally found the issue, and it has to do with the OLD_PASSWORD directive...

I did this from the DOS command line...


........................................................

type MySQL -u root -p
-password: your-password(press enter)

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('your_pass')
-> WHERE Host = 'localhost' AND User = 'root';
mysql> FLUSH PRIVILEGES;
mysql>\q


........................................................

Worked like a champ!!!



Steve

If I'd had seen your initial post I'd have saved you a tonne of time. Been there, done that, wrote the FAQ! - sorry.

https://xoops.org/modules/smartfaq/faq.php?faqid=483

Ted

I wish I saw your post earlier!!! This is exactly the problem that I had Spent 1+ hour on it~ It's a good idea to post it under FAQ