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.

47 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 said...

Saya menyukai artikel anda, terima kasih


ST3 Telkom

Unknown said...

Thank you for the information...


ST3 Telkom

Unknown said...

Thanks you for share and interesting ..


ST3 Telkom


Hasilbertapa 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

Hasilbertapa 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

sitampan 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/

wkpoi said...

saksikan live draw togel paling cepat di bawah ini
live draw sydney
live draw hk
live draw sgp
live draw hk 6d
prediksiwla
singapore pools
https://dtogel.com/
di atas merupakan situs live draw terbaik di indonesia

ratuqq said...

Lihat prediksi Syair, paito warna, dan hasil result data togel terupdate di sini :
Syair SGP
Bocoran SGP
paito warna china
paito warna
hasil result
hasil data
semoga dengan website di atas dapat membantu kalian semua.

wkpoi said...

jika ingin melihat paito warna paling lengkap kalian bisa mengunjungi website di bawah ini
paito warna hk
paito warna hk 6d
paito warna
paito singapore
paito sydney
paito hongkong
di atas merupakan situs paito warna terlengkap dan terbaik di indonesia

for ict 99 said...

A IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.



Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

paitowarnasaia said...

situs di bawah ini ialah situs yang mengumpulkan keluaran angka togel serta paito warna yang fungsinya membantu para pemain togel membuat prediksi angka togel
pengeluaran togel
paito warna
data togel
togel cambodia
paitowarna

dedisomekuy said...

paito warna sydney

paito warna hongkong

paito warna singapore

paitowarna

dedisomekuy said...

togel cambodia

data sidney

data hongkong

togel singapore

paito warna china

UNWEB88 said...

Judi slot online adalah salah satu jenis situs judi slot online uang asli, dan karenanya segeralah daftarkan diri anda di judi slot online untuk bisa main di situs judi slot online dengan mudah dan nyaman.

backlinkpaito said...

paito warna
paitowarna
paito warna sydney
paito warna hongkong
paito warna singapore
togel cambodia
data sidney
data hongkong
togel singapore
paito warna china

datapaito.site said...

paito warna morocco 21
paito warna morocco 00
paito warna north carolina day
paito warna oregon 04
paito warna oregon 07
paito warna oregon 10
paito warna oregon 13
paito warna pcso
paito warna singapore
paito warna sydney

datapaito.site said...

paito warna
paito warna cambodia
paito warna china
paito warna georgia midday
paito warna georgia night
paito warna hongkong
paito warna kentucky midday
paito warna bullseye
paito warna morocco 03
paito warna morocco 18

paitotogel said...

paito warna hk
paito warna singaore
paito warna syd
paito warna kamboja
paito warna china
paito warna

vegaspaito.online said...

paito warna hongkong
paito warna china
paito warna

datapaitoolss said...

paito warna hongkong
paito warna singapore
paito warna sydney
paito warna cambodia
paito warna china
paito warna

datapaitoolss said...

paito warna hongkong
paito warna singapore
paito warna sydney
paito warna cambodia
paito warna china
paito warna

Unknown said...

نقل عفش من الرياض الى مصر نقل عفش من الرياض الى مصر
نقل عفش بالدمام نقل عفش بالدمام
نقل عفش بالاحساء نقل عفش بالاحساء
نقل عفش داخل مكة نقل عفش داخل مكة

Thanks for your post! See also

شركة شحن عفش من الرياض الى الامارات
شركة شحن عفش من الرياض الى الاردن


REKAP DATA said...

seputar blog togel

seputar blog togel

seputar blog togel

The One said...

So you suspect your harddisk is defective and you will need some support? We are able to unquestionably support you at our company places of work situated in the heart of Sydney CBD.
Seputar Togel
Seputar Togel
Seputar Togel

REKAP DATA said...

blog togel online
blog togel online
blog togel online

prediksi said...

pengertian dalam memainkan suatu permainan di butuhkan skill yang baik, dan cerdas pada saat bermain pada sebuah website tersebut

keluaran data togel
prediksi angka togel
bandar togel bonafit
forum syair prediksi
Paito Warna Terlengkap

adventuretogel said...

paito warna singapore
paito warna sydney
paito warna hongkong

paito warna sydney
paito warna singapore
paito warna hongkong

datapaito.site said...

paito warna
paito warna cambodia
paito warna china
paito warna hongkong
paito warna singapore
paito warna sydney

andre taulany said...

result hasil data togel

vegas group said...

live draw hk

andre taulany said...

live draw sydney tercepat

Related Post :