[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Reset MySQL Server Password on Windows 7 64bit

Posted on 2013-06-18
2
Medium Priority
?
405 Views
Last Modified: 2013-06-23
Hi all:
I lost the root password of MySQL 5.1, I've read all the articles about the reset of the password, I am trying all methods but no way. So strange I am follow the steps exactly
error msgCan you help me
0
Comment
Question by:khaled salem
2 Comments
 
LVL 26

Accepted Solution

by:
Tomas Helgi Johannsson earned 2000 total points
ID: 39258570
Hi!

This is not an error message. Just a warning saying that the default-character-set is depricated and is reported because it is used in the my.ini file.

If you have followed the manual
http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html
then you should be able to restart the mysql server and be able to connect to the database using the new root password.

Make sure you execute the commands in an Administrative cmd console.

Regards,
    Tomas Helgi
0
 
LVL 15

Expert Comment

by:Insoftservice
ID: 39268509
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question