HELPPPPPPPP MYSQL

cowboy47

Joined
Jun 14, 2007
Messages
276
Likes
0
Points
0
#1
OK, How I did this, I have no clue but I managed to change the root password in mysql. I have spent hours going through the web trying to find ways of repairing this but all to no avail. I need some sort of guidance on how to repair this issue or if I do a reinstall, how to recreate the databases, without having to do a complete reinstall of the 0.8.4 system.

C

:blush:
 

cowboy47

Joined
Jun 14, 2007
Messages
276
Likes
0
Points
0
#2
BIG BUMP. Please somebody give me a hand.
 

bogus

Joined
Jul 8, 2007
Messages
5
Likes
0
Points
0
#3
Hi,

may be you try this:

How to Reset a MySQL Password in 5 Easy Steps

1. Stop the mysqld daemon process.
2. Start the mysqld daemon process with the --skip-grant-tables option.
3. Start the mysql client with the -u root option.
4. Execute the UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
5. Execute the FLUSH PRIVILEGES; command.

These steps reset the password for the "root" account to "password". To change the password for a different account, or to set a different password, just edit the variables in single-quotes in step 4.

If you know your existing MySQL root password, steps 1-3 are not necessary.

found at www.tech-faq.com
 

dbbrito

Joined
Jul 22, 2007
Messages
12
Likes
0
Points
0
#4
I did not understand the steps, can explain me better
 

cowboy47

Joined
Jun 14, 2007
Messages
276
Likes
0
Points
0
#5
Thanks, that helps. Unfortunately in my case, the root user password was unknown because of fat fingering it. So, I ended up having to do a complete reinstall.

I strongly recommend that everyone install webmin & make a backup of all your sql databases.

C
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,902
Messages
130,886
Members
17,563
Latest member
dineshr
Top