Anyway to change a MySql password via phpmyadmin?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Juicy D. Links
    So Fucking Banned
    • Apr 2001
    • 122992
    #1

    Anyway to change a MySql password via phpmyadmin?

    I know its encrypted when you view it but taking a shot in the dark any way of doing this?


    X0X0

    -JDL
    Tags: None
    • GrouchyAdmin
      Now choke yourself!
      • Apr 2006
      • 12085
      #2
      Well, yeah, if you have access to the users table. Duh.

        Comment

        • Juicy D. Links
          So Fucking Banned
          • Apr 2001
          • 122992
          #3
          Originally posted by GrouchyAdmin
          Well, yeah, if you have access to the users table. Duh.
          Yeah i do for example

          user "juicy"

          pass "a3fd82430bee5f99dd7ebf2ad07c2baa"


          the pass i can just change it for example to "burp" and it will be ok?

          thx in advance

            Comment

            • Juicy D. Links
              So Fucking Banned
              • Apr 2001
              • 122992
              #4
              i was always under assumption that in the table for password such as


              pass "a3fd82430bee5f99dd7ebf2ad07c2baa" <----som sort of encrypted thingy

                Comment

                • Varius
                  Confirmed User
                  • Jun 2004
                  • 6890
                  #5
                  Hey Juice, long time

                  It depends what way it's encrypted, usually the two most common ways are going to be MySQL's default password function or md5, in which case you can do either of:

                  UPDATE table SET password=PASSWORD('newone') WHERE user='juicy';

                  or

                  UPDATE table SET password=md5('newone') WHERE user='juicy';
                  Skype variuscr - Email varius AT gmail

                    Comment

                    • directfiesta
                      Too lazy to set a custom title
                      • Oct 2002
                      • 30137
                      #6
                      you need to repace it with an encrypted password ( MD5)

                      http://md5encryption.com/
                      I know that Asspimple is stoopid ... As he says, it is a FACT !

                      But I can't figure out how he can breathe or type , at the same time ....

                        Comment

                        • Domain Broker
                          So Fucking Banned
                          • Oct 2004
                          • 2427
                          #7
                          change the varchar to md5

                            Comment

                            • Juicy D. Links
                              So Fucking Banned
                              • Apr 2001
                              • 122992
                              #8
                              Originally posted by Varius
                              Hey Juice, long time

                              It depends what way it's encrypted, usually the two most common ways are going to be MySQL's default password function or md5, in which case you can do either of:

                              UPDATE table SET password=PASSWORD('newone') WHERE user='juicy';

                              or

                              UPDATE table SET password=md5('newone') WHERE user='juicy';
                              Originally posted by directfiesta
                              you need to repace it with an encrypted password ( MD5)

                              http://md5encryption.com/
                              Originally posted by Domain Broker
                              change the varchar to md5

                              cool thx everyone I am gonna test it out now I love u alll

                                Comment

                                • woj
                                  <&(©¿©)&>
                                  • Jul 2002
                                  • 47882
                                  #9
                                  may need to "flush privileges" too
                                  Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
                                  Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
                                  Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

                                    Comment

                                    • GrouchyAdmin
                                      Now choke yourself!
                                      • Apr 2006
                                      • 12085
                                      #10
                                      then click your ruby slippers three times and repeat 'there's no password like 68b329da9893e34099c7d8ad5cb9c940, there's no password like 68b329da9893e34099c7d8ad5cb9c940, there's no password like 68b329da9893e34099c7d8ad5cb9c940'

                                        Comment

                                        Previous template Next
                                        Working...