Need MySQL help with root password

Heeter

Overclocked Like A Mother
Joined
8 Jul 2002
Messages
2,732
Hey all,

First off, I am using MySQL 4.1.2. It has been running absolutely flawlessly for the last three years or so.

Throughout all this time, my phpmyadmin has always complained that my root password has never been set.

So I decided to look up how to set the password last night, and on MySQl help pages, I found a step by step guide on how to setup/reset the password for root.

Well much to my dismay, it didn't work, now my mysql service cannot restart.

I am wondering if anyone knows what to do to get me out of this jam?


Thanks,


Heeter
 

Heeter

Overclocked Like A Mother
Joined
8 Jul 2002
Messages
2,732
That was exactly the howto's that I was using. Who knew.

I managed to get sqlyog free edition to run, and I went into the mysql default db, and remove the offending entries. Everything is restarted now upon Server reboot, but Apache is giving me errors. Looks like everything is running and phpmyadmin is back to bitching that I don't have a root password. All is good again.

This will remind me of something: If it broke, don't fix it.

This came close to ruining my webserver, as all my client invoicing, and my database creation php's is done through Mysql.


Thanks for the help Carpo.


Heeter
 

X-Istence

*
Political Access
Joined
5 Dec 2001
Messages
6,498
So where is this website hosted? :p

Having no root password set for MySQL is like asking people not to just walk into a house with the front door removed. You need to set a password for root, and make it fast. Otherwise all your clients information could be out on the "street" tomorrow or whenever an attacker finds out about this.
 

Members online

No members online now.

Latest profile posts

Electronic Punk wrote on Sazar's profile.
Rest in peace my friend, been trying to find you and finally did in the worst way imaginable.
Terrahertz wrote on Electronic Punk's profile.
Yo fellas!
Electronic Punk wrote on Sazar's profile.
Where are you buddy?
Perris Calderon wrote on Electronic Punk's profile.
Hey EP! All good with me, applying for Microsoft MVP right now, should have done this a while ago.

Notifications don't work, I only found your response by coming back to hunt up some threads, if you want, give me your email address so we can keep in touch easier!
Perris Calderon wrote on Electronic Punk's profile.
EP, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there!

Forum statistics

Threads
61,997
Messages
673,411
Members
5,590
Latest member
AntonioPR