mysql help google isn't working well

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Tony Montana
    Confirmed User
    • Jan 2005
    • 794
    #1

    mysql help google isn't working well

    I currently don't have grant priviledges on my mysql account

    I don't remember the damn root password

    I need to add another user but it wont' let me

    I run windows servers and it won't even let me do it from command because i don't know the root password

    How can I get password for root or how can I add another user with grant options?

    I am a marketing Genius.
    Tags: None
    • Tony Montana
      Confirmed User
      • Jan 2005
      • 794
      #2
      Oh, also. I have root access to the server. I don't think passwords are stored in any certin files(if so i'm guessing their encypted 128bit+)?
      I am a marketing Genius.

        Comment

        • Jon2
          So Fucking Banned
          • Aug 2001
          • 2875
          #3
          Originally posted by Tony Montana
          I run windows servers

          You lost me at this

          Jon

            Comment

            • Babaganoosh
              ♥♥♥ Likes Hugs ♥♥♥
              • Nov 2001
              • 15841
              #4
              Check if the root password is blank. If you don't remember setting it, it may very well be blank.
              I like pie.

                Comment

                • Tony Montana
                  Confirmed User
                  • Jan 2005
                  • 794
                  #5
                  Originally posted by Babaganoosh
                  Check if the root password is blank. If you don't remember setting it, it may very well be blank.
                  I was trying no password before. Tried just putting a password with it blank, didn't work
                  I am a marketing Genius.

                    Comment

                    • VideoJ
                      Confirmed User
                      • Aug 2002
                      • 750
                      #6
                      shut down mysqld and restart it with the --skip-grant-tables option. that ignores the password protection, you can reset the root password and then restart it again. That's how you can fix it in unix land, windows is similar i think
                      Somebody stole my damn signture...

                        Comment

                        Previous template Next
                        Working...