How To Reset Mysql Password In Centos Using Ssh

Discussion in 'Site & Server Administration' started by SagarRox, Jan 20, 2013.

0
  1. #1
    This small tutorial will teach you how to Reset your MySQL Password in CentOS using SSH

    Stop MySQL:
    [root#] service mysqld stop

    Start MySQL in safe mode:
    [root#] mysqld_safe --skip-grant-tables &

    Log into MySQL as root:
    [root#] mysql -u root

    Reset the password:
    mysql> update mysql.user set password=PASSWORD("NewPassword") where User='root';
    mysql> flush privileges; exit;

    Log out of MySQL and stop the Safe Mode:
    [root#] service mysqld stop

    Start MySQL in the normal mode:
    [root#] service mysqld start

    Log into MySQL with your new password:
    [root#] mysql -u root -p

    Enter password:
    mysql>
     
    SagarRox, Jan 20, 2013 IP
  2. toastbeer

    toastbeer Greenhorn

    Messages:
    12
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    #2
    toastbeer, Jan 23, 2013 IP
  3. getadviced

    getadviced Well-Known Member

    Messages:
    557
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    130
    #3
    says "service" command not found. Is there any other way to stop it?

    - Worked by adding /sbin/service
     
    Last edited: Aug 8, 2013
    getadviced, Aug 8, 2013 IP