Как сменить пасс на root в mysql?

Discussion in 'Linux, Freebsd, *nix' started by podkashey, 19 Aug 2008.

  1. podkashey

    podkashey С крышкой по жизни!

    Joined:
    18 Jun 2005
    Messages:
    756
    Likes Received:
    351
    Reputations:
    353
    Сабж, на системе имею рута.
     
  2. OdaN

    OdaN Elder - Старейшина

    Joined:
    4 Mar 2006
    Messages:
    192
    Likes Received:
    17
    Reputations:
    1
    Code:
    mysqladmin -u root -p password “my new password” 
    Как-то так
     
    #2 OdaN, 19 Aug 2008
    Last edited: 19 Aug 2008
  3. aka PSIH

    aka PSIH Elder - Старейшина

    Joined:
    7 Feb 2006
    Messages:
    582
    Likes Received:
    284
    Reputations:
    51

    p.s: ось какая?
     
    #3 aka PSIH, 19 Aug 2008
    Last edited: 19 Aug 2008
  4. podkashey

    podkashey С крышкой по жизни!

    Joined:
    18 Jun 2005
    Messages:
    756
    Likes Received:
    351
    Reputations:
    353
    я пароля админского не знаю, ось фряха
    ман от психа на помог, читал его уже
     
  5. SpangeBoB

    SpangeBoB Elder - Старейшина

    Joined:
    12 Jul 2008
    Messages:
    1,680
    Likes Received:
    393
    Reputations:
    102
    http://www.cyberciti.biz/tips/recover-mysql-root-password.html
     
  6. guest3297

    guest3297 Banned

    Joined:
    27 Jun 2006
    Messages:
    1,246
    Likes Received:
    639
    Reputations:
    817
    залогниться под привелегированным юзером и отредактировать mysql.user конкретно отредактировать учетку root предварительно зашифровав свой новый пароль в mysql или mysql5 в зависимости от версии. ребутнуть демон.
     
    1 person likes this.
  7. c411k

    c411k Members of Antichat

    Joined:
    16 Jul 2005
    Messages:
    550
    Likes Received:
    675
    Reputations:
    704
    http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

    killall -9 mysqld
    mysqld --skip-grant-tables
     
    _________________________
    1 person likes this.
  8. feonova

    feonova New Member

    Joined:
    21 Jun 2008
    Messages:
    0
    Likes Received:
    1
    Reputations:
    0
    http://www.opennet.ru/openforum/vsluhforumID9/6142.html вот тут псмотри!
     
    1 person likes this.
  9. Nelzone

    Nelzone Banned

    Joined:
    12 Apr 2008
    Messages:
    172
    Likes Received:
    134
    Reputations:
    6
    а не судьба через фтп залит config и сменить пасс
    user:'root
    pass'zabil'