.:: Nhie

  • Review
  • Kuliner
  • Jalan – jalan
  • Kopdar
  • Life Story
  • Parenting

Reset password mysql di Ubuntu 10.10

Posted on January 19, 2011

Ya …ya…ya. saya emang orangnya pelupa bin kadang loss connection. hahahhahahahha *bangga sama diri sendiri* Bego!!!.

Ntah, saya juga lupa ini mysql-nya saya apakan yah? tiba-tiba request phpmyadmin itu not found. Padahal pertama kali install apache, php dan mysql-nya itu semua berjalan normal termasuk phpmyadmin-nya dapat sy akses dengan baik. Tetapi…oh tetapi pas masuk pada pembelajaran database ….eeeh request phpmyadmin error. ckckckck payah!!. Dan mau connect ke mysql-nya…tetooooot!! sy lupa password hahahahahahhah!! payah kuadrat!!

walhasil, selama kuliah tadi saya hanya sibuk bergeriliya di oom google. hahahahhahah!!.

oh ok, langkah pertama yang dilakukan untuk reset password adalah mematikan service mysql-nya :


root@Nhie:~# /etc/init.d/mysql stop
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql stop
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) utility, e.g. stop mysql
mysql stop/waiting

selanjutnya restart mysqld daemon-nya dengan mengeetikan command :

root@Nhie:~# mysqld_safe --skip-grant-tables &

Hasilnya :


[1] 4715
root@Nhie:~# 110119 23:49:49 mysqld_safe Logging to syslog.
110119 23:49:49 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

selanjutnya masuk ke mysql-nya

root@Nhie:~# mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.1.49-1ubuntu8.1 (Ubuntu)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql>

setehal berhasil masuk ubahlah password dari mysql dengan menggunakan command :

mysql> update user set password=password('passwordYgDiinginkan') where user='root';

hasilnya :

Query OK, 3 rows affected (0.08 sec)
Rows matched: 3 Changed: 3 Warnings: 0

sampai disini password mysql telah berhasil direset. Jangan lupa untuk menyimpan selamanya konfigurasi yang telah kita ubah dengan mengetikkan command :

mysql> flush privileges;

Hasilnya :

Query OK, 0 rows affected (0.00 sec)
mysq>

Untuk mengeceknya, silahkan keluar dari mysql promt kemudian masuk lagi dengan command
#mysql -u root -p masukkan password yang baru.

semoga setelah ini saya tidak lupa lagi passwod mysql-ku!! :D.

selamat mencoba, semoga bermanfaat. 🙂

« Unik
Masak Musik »

35 Responses

Comment navigation

← Older Comments
  1. dodatkowe zródlo says
    October 11, 2017 at 09:38

    I rattling delighted to find this internet site on bing, just what I was looking for : D as well saved to bookmarks .

    Reply
  2. comment avoir des plus gros seins says
    October 11, 2017 at 13:16

    Some genuinely nice and useful information on this website, besides I think the design has got superb features.

    Reply
  3. comment maigrir sans régime says
    October 11, 2017 at 13:22

    obviously like your website however you need to test the spelling on several of your posts. A number of them are rife with spelling issues and I find it very troublesome to tell the reality then again I will surely come back again.

    Reply

Comment navigation

← Older Comments

Leave a comment

Leave a comment Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Archives

Recent Posts

  • Beli tiket nonton bioskop online atau Offline?
  • Pengalaman Saya Saat Menetap di Daerah KLB Difteri
  • So Good Spicy Chicken Strip, Jawaranya Chicken Strip!
  • Keseruan Viva Lova Blogger Gathering di Dunia Fantasi
  • Cegah Infeksi Saluran Kemih dengan Prive Uri-cran

Member In

Blogger Perempuan
 

CyberChimps WordPress Themes

© Nhie...