Change user password in sql

Discussion in 'Databases' started by ASTRAPI, Nov 14, 2008.

  1. #1
    Hi

    I use direct admin as a panel in my forum and phpmyadmin.

    How can i change the password from the user that is connected to the database?

    I will change it also in the config file of my forum to be ok.

    Thanks
     
    ASTRAPI, Nov 14, 2008 IP
  2. winjin92

    winjin92 Peon

    Messages:
    19
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    What's ur Cpanel ?
    If u use CPx u click to " Database Manager " ~> clich Password and change it !
     
    winjin92, Nov 14, 2008 IP
  3. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    my panel is direct admin
     
    ASTRAPI, Nov 15, 2008 IP
  4. gdi

    gdi Peon

    Messages:
    356
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #4
    All direct admin panels use PhpMyAdmin
    go to http://yourdomainname.com/phpMyAdmin/ and select the database you want to change your password

    find the table where is the password and your username, and change in from there. before do this copy a backup of your sql file. change the user name or password and save the changes :)

    this is all

    note : if you are using wordpress your user name and password is under wp_users table
     
    gdi, Nov 15, 2008 IP
  5. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    ok thanks :)
     
    ASTRAPI, Nov 15, 2008 IP