Abdul Hakim

Abdul Hakim

Cloud | DevOps Enthusiast

© 2020

Cara Reset Password Root di MariaDB Linux

  1. Matikan service mysql

    $ sudo /etc/init.d/mysql stop
    
  2. Jalankan safe mode di mariadb untuk masuk kedalam database tanpa menggunakan password

    $ sudo mysqld_safe --skip-grant-tables &
       
    
    [1] 24361 
    $180426 10:20:56 mysqld_safe Logging to syslog.
    180426 10:20:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
    
  3. Jalankan mariadb

    $ mysql -u root
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 1
    Server version: 5.5.33a-MariaDB MariaDB Server
       
    Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.
       
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    MariaDB >
    
  4. Reset password mariadb

    MariaDB [(none)]> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Database changed
       
    MariaDB [mysql]> update user set password=PASSWORD("new_password;") where User='root';
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
       
    MariaDB [mysql]> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
       
    MariaDB [mysql]> quit
    Bye
    
  5. Restart mariadb

    $ sudo /etc/init.d/mysql restart
    

    Selesai. Sekarang coba masuk kedalam mariadb menggunakan password yang baru kita ubah tadi

    # mysql -u root -p
    Enter password: 
    Welcome to the MariaDB monitor.  Commands end with ; or \g.
    Your MariaDB connection id is 4
    Server version: 10.1.29-MariaDB-6 Debian buildd-unstable
       
    Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
       
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
    MariaDB [(none)]>
    

    Jika masih gagal untuk masuk dengan menampilkan pesan error seperti dibawah ini :

    ERROR 1698 (28000): Access denied for user 'root'@'localhost'
    

    Lakukan proses yang sama hingga langkah 3 diatas kemudian lakukan perintah dibawah ini :

    MariaDB [(none)]> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Database changed
       
    Database changed
    MariaDB [mysql]> UPDATE user SET plugin="";
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
       
    MariaDB [mysql]> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
       
    MariaDB [mysql]> quit
    Bye
    

    Kemudian coba lagi untuk masuk kedalam MariaDB.

    Semoga Berhasil…