MySQL Password lost

  • Posted: 13 February 2002 01:45 AM

    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?

    Signature

    Tjeerd van Hoytema

    —-
    Join us at irc.macobserver.com #macobserver

         
  • Posted: 08 February 2002 08:43 PM #1

    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>

    Signature

    Evil® takes many forms. Please submit them promptly, in triplicate.

         
  • Posted: 09 February 2002 02:02 PM #2

    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 .

    Signature

    Tjeerd van Hoytema

    —-
    Join us at irc.macobserver.com #macobserver

         
  • Posted: 13 February 2002 01:45 AM #3

    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™

    Signature

    Evil® takes many forms. Please submit them promptly, in triplicate.