Cara Reset Password Root di MariaDB Linux

Written by   on  


1. Matikan service mysql

$ sudo /etc/init.d/mysql stop

2.Jalankan safe mode di maria db untuk masuk ke dalam 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...


Share:

Cara Intall Apache Spark di Linux

Written by   on  



 1. Install Java

     Memeriksa apakah java SDK (Standar Development Kit) dan JRE(Java Runtime Environment) sudah terinstall di OS kita
$ java -version


 Pada gambar diatas telihat versi java SDK yang digunakan ialah versi 1.8.0_131
serta versi JRE 1.8.0_131 serta telah terinstall.


Jika belum diinstall,kita bisa mendownload SDK dan JRE terlebih dahulu di
http://www.oracle.com/technetwork/java/javase/downloads/index.html
Setelah itu ekstrak filenya kemudian masukkan kedalam PATH Environment

2.  Install Scala


 - Download scala di http://www.scala-lang.org/download/
 - Ekstraks file scala
$ tar xvf scala-2.12.3.tgz
$ sudo -i
# cd /home/nisty/Downloads/
# mv scala-2.12.3 /usr/local/scala/
# exit
$ export PATH=$PATH:/usr/local/scala/bin
$ scala -version
















3. Install Apache Spark

- Download Apache Spark di https://spark.apache.org/downloads.html
$ tar xvf spark-2.2.0-bin-hadoop2.7.tgz
$ sudo -i
# cd /home/nisty/Downloads/
# mv spark-2.2.0-bin-hadoop2.7 /usr/local/spark/
$ export PATH=$PATH:/usr/local/spark/bin
$ spark-shell


Untuk menjalankan di user interface web akses browser dengan alamat http://192.168.1.23:4040 terlihat pada gambar diatas itu adalah alamatnya .
Bisa jadi alamatnya berbeda, sesuaikan dengan alamat yg diberikan.



Share: