Reset Password Root MySQL di Ubuntu

Posted on 24 June 2012 by

Salam OpenSource, sebelumnya di posting sebelumnya saya sudah janji kepada teman-teman semua untuk sharing tentang Bagaimana me-reset password Root di MySQL. Ok, tidak perlu panjang lebar, langsung saja menuju ke…TKP hehehe..

Sebelumnya kita sudah menginstal MySQL di dalam Ubuntu kita, tetapi karena kebanyakan password yang kita harus ingat, suatu ketika kita lupa dan ingin mengakses database yang sudah kita create di MySQL. Pertama kalinya kita harus mengehentikan terlebih dahulu service MySQL :

Buka terminal dan ketikkan :

# /etc/init.d/mysql stop

Restart MySQL dan disable network communication dan abaikan athentication procedure

# mysqld  –skip-grant-tables –skip-networking &

Setelah itu kita melakukan proses Reinitializing password nbso online casino reviews dengan cara :

# mysql mysql -u root

Kemudian ketikkan perintah berikut :

# UPDATE user SET password=PASSWORD(“newpassword”) WHERE user=”root”;

Jika proses itu tidak berhasil, maka kembali ke langkah pertama kemudian ketikkan :

FLUSH PRIVILEGES;

Jika kamu memulai proses MySQL dengan cara manual, maka restart server database MySQL dengan mengetikkan :

# /etc/init.d/mysql restart

 

Demikian sharing dari saya, saya ucapkan terima kasih sebanyak-banyaknya. Salam Opensource Indonesia!

14 Comments

http://www./

29 January 2017

yes he would feel compelled to tell simply because it jeopardizes a temple recommend. He would also do the same if he saw a member buying a bottle of Jack Daniels. I’m guessing my husband is in the minority.


http://www./

11 January 2017

ho creduto alla versione ufficiale, almeno non a tutta, però non ho mai seguito ben bene le teorie che la negano. Già che ti vedo preparato, vorrei chiederti se hai una possibile versione alternativa sull'aereo del Pentagono: tipo…è esistito?


http://www./

14 November 2016

Grade A stuff. I’m unquestionably in your debt.


http://www./

14 November 2016

Interestingly, this is the second recent remake involving Colin Farrell. I'm a huge fan of FRIGHT NIGHT so was very cautious about seeing that particular remake. The only thing that might get me to watch it on cable is the almighty David Tennant.Sure the original TOTAL RECALL differed from the PKD material, but it was one of Arnie's best movies for what it was – some nifty SF-nal ideas and lots of dumb action. I haven't watched this trailer yet (and probably won't until it comes across my TV screen) so I can't speak to its merits either way, but plan on avoiding it.


Post a Comment

Your email is never shared.