I installed MySQL and PHP to use my server for more things, but (stupid as I am) I lost my MySQL password. In what file in my system is it stored, or what other ways do I have to retrieve it, or in the last case, how do I reinitialize MySQL and reset the password?

Heya,

Sorry nobody responded. I don’t know either, so I asked An Expertâ„¢.

(04:38) Raena: Ohh yeah. that reminds me. what do you do if you lost (!) your SQL pass? (and you’re the admin so there’s no big important person to tell you)
(04:38) Raena: (see http://www.macobserver.com/forums/viewtopic.php?topic=3647&forum=26&0 )
(04:39) jonknee: just rm -rf it
(04:39) jonknee: and reinstall
(04:39) Raena: that won’t shoot yr database?
(04:39) jonknee: yeah it will
(04:40) Raena: aw. not good.
(04:40) jonknee: he can’t have too much in there if he is silly enough to forget the pw
(04:40) Raena: can you… just back it up and put it back in once you reinstalled?
(04:40) Raena: LOL
(04:40) jonknee: yeah but you need your pw to back it up
(04:40) jonknee: he could look at mysql.com
(04:40) jonknee: but i don’t know off my head
(04:40) Raena: nuts

So says The Expertâ„¢.  And yay for AIM.  And he says to say he meant ‘silly’ as in ‘oops!’, not lame.

<font size=-1>[ This Message was edited by: Raena on 2002-02-09 00:47 ]</font>

Thanks Raena, and by the way, what a real nice guy the Expertâ„¢ of yours.       I guess I’ll have rm -rf all mySQL things, no biggie, just as the Expertâ„¢ said, there can’t be much in them, well there isn’t .

I should hope not.

Tattoo it on the sole of your foot, or something.*

May I ask what you’re tinkering with?  I need to learn more about MySQL and I want to practice on my machine.

________________
* Opinion not endorsed by anyone, especially not the Expertâ„¢