Tuesday, April 7, 2009

Change and Reset MySQL 'root' Password

Ada kalanya kita lupa akan sesuatu, termasuk lupa password root dari MySQL Server di komputer kita. Namun jangan khawatir karena semua pasti ada solusinya. Mungkin langkah-langkah berikut patut dicoba untuk mengganti password root di MySQL Server.


  1. Stop MySQL server dengan perintah :

    $sudo /etc/rc.d/init.d/mysql stop

  2. Start the MySQL server dengan menambahkan parameter –skip-grant-tables :

    $sudo mysqld_safe --skip-grant-tables &

  3. Login ke MySQL server dengan menggunakan root :

    $sudo mysql -u root mysql

  4. Update tabel user untuk mengubah password root MySQL server :

    mysql> UPDATE user SET Password=PASSWORD(’newrootpassword’) WHERE User=’root’;
    mysql> FLUSH PRIVILEGES;

    Note: Replace newrootpassword with the new root password for MySQL server. Flush Privileges is needed to making the password change effect immediately.

  5. Keluar dari MySQL server dengan perintah exit.

  6. Restart MySQL server dengan perintah :

$sudo /etc/rc.d/init.d/mysql restart



Suksesssssss.

Catatan : Langkah-langkah tersebut sudah di coba di Ubuntu 8.10.

22 comments:

Benjol said...

nice artikel ....

chris said...

nice artikel boss..:D
lage belajar buat linux nie...maklum masih newbie..:D

Lutfi said...

nie jg br bljar maz .... he

Adel Jopong said...

Thanks for your post really helped me awaited other stuff ..



ST3 Telkom

Vonie Cornelia said...

Artikel ini sangat menarik. Terimakasih telah berbagi informasi. Informasi ini sangat membantu

ST3 Telkom

Oktisa Rahmawati Choerun Nisa said...

Saya menyukai artikel anda, terima kasih


ST3 Telkom

dina lestari said...

Thank you for the information...


ST3 Telkom

zelvia dwi said...

Thanks you for share and interesting ..


ST3 Telkom


Hasil Bertapa said...

Wow, superb from you! Glad that i found your site today. I'll bookmark your website and come back soon. Btw, how do i get more information about this? vien danke! https://hasilbertapa.live/nomor-pengeluaran-togel-hongkong-2018

Hasil Bertapa said...

I ‘d mention that we site visitors are extremely lucky to live in a fantastic community with very many awesome people with interesting principles. I feel very happy to have seen your weblog and look forward to some more cool moments reading here. Thanks once again for all the details. https://hasilbertapa.info/hasil-togel-singapore/

juegos friv 2021 said...


The article you have shared here very awesome. I really like and appreciate your work. I read deeply your article, the points you have mentioned in this article are useful. Thanks!

bola88 said...

akiprediksi
bandar judi
idnpoker
interqq

Anonymous said...

bandar togel
dewaqq
kristalqq

data sgp said...

In the wake of perusing the article you composed, I wound up mindful of numerous things. Much thanks to you for composing this great article.data sgp

data sgp said...

I truly like your article, I think your article is useful and fascinating, however I figure you should additionally clear up the expectation of your article.Data HK

data sgp said...

I truly like your article, I think your article is useful and fascinating, however I figure you should additionally clear up the expectation of your article..

ecommerce said...

good tips man.. kinda surprised..

Anonymous said...

dewaqq
sumoqq
interqq
pionpoker
betgratis
paito warna
warung prediksi

Unknown said...

pasarqq
wedeqq
agen togel
interqq
paito singapore
result togel
judi togel terpercaya
bandar sgp

Joker123 said...

situs agen judi slot online terpercaya
daftar joker123
Joker123
Daftar Joker123
Joker Gaming
http://datasgp88.com
https://ltdown21.com
http://dedetizacaodecarunchos.com

Merlin Kristianti said...

asikqq
dewaqq
sumoqq
interqq
hobiqq
rajawaliqq
http://192.254.236.33/hobiqq78/
paito warna terlengkap
paito warna singapore
paito warna sydney

wkpoi said...

link alternatif adalah salah satu cara untuk membuka situs pelangiqq untuk menyalurkan hobi main hematqq dan cara asik main online di anekaqq dengan sangat asikqq dan menjadi dewaqq dan ratuqq yang di sediakan oleh paito warna hk sumber : http://paitowarna.cc/

Related Post :