troubleshooting Question

How to Reset the Root Password MySQL 4.1

Avatar of cybersharks1
cybersharks1 asked on
MySQL ServerWindows Server 2003Microsoft Server OS
8 Comments1 Solution1767 ViewsLast Modified:
Hi Experts,
  We have lost the password for MySQL 4.1 for the root/sa user.

We are using MySQL front and trying to connect so we can create/UN/db.

How can you reset the password for MySQL 4.1 or if you install 4.1 will it overwrite the old information Databases and logins?

Also could we just upgrade to 5.0 and not lose any data either I will just be able to create a new login?

These links below seemed to work in the CMD but still won't let me login.

http://www.issociate.de/board/post/272629/root_password.html

This one seem to work and on the CMD promt it took like 3 sec and executed the command but the login didn't change.  I must be doing something wrong.  
http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 8 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros