Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to recover the root password in mysql

Posted on 2011-04-28
4
Medium Priority
?
665 Views
Last Modified: 2012-05-11
I have server with RHEL5, and mysql which contains valuable data, but I forgot the root pasword, packages installed related to mysql are:
mysql-5.0.77-3.el5
php-mysql-5.1.6-24.el5_4.5
mysql-5.0.77-3.el5
perl-DBD-MySQL-3.0007-2.el5
mysql-server-5.0.77-3.el5
mysql-connector-odbc-3.51.26r1127-1.el5
libdbi-dbd-mysql-0.8.1a-1.2.2
MySQL-python-1.2.1-1

Can someone please guide me on a safe way how to recover my root password without loosing my data nor deleting other users nor reseting their passwords?
0
Comment
Question by:Ashraf-Hassan
4 Comments
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 2000 total points
ID: 35489198
0
 
LVL 3

Expert Comment

by:wuyinzhi
ID: 35489199
0
 
LVL 21

Expert Comment

by:K V
ID: 35489976
0
 
LVL 25

Expert Comment

by:madunix
ID: 35490005
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
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…

572 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