Reset Password Mysql

by tyo - 03-23-2016 at 04:59 PM
Junior Member
Posts:
10
Joined:
Mar 2016
Likes:
0
Reputation:
0
2 Year Of Member
#1
OP
Posted: 03-23-2016, 04:59 PM
Pernah lupa password mysql ?? atau mau rubah password mysql punya teman ??  :D

ini nih cara buat ganti password root mysql. Login sebagai root

# /etc/init.d/mysql stop

Stop dulu service mysql nya

# mysqld_safe --skip-grant-tables &

perintah tersebut akan menjalankan mysql dan melewati user privileges.

# mysql

masuk ke console mysql.

> use mysql;

memilih database mysql yang di dalamnya ada tabel user.

> update user set Password=PASSWORD('testestes') where user='root';

ini buat ganti password dari user root nya mysql. ganti testestes dengan password yang kamu inginkan.

> exit;

keluar console mysql.

# kill %1

hentikan proses mysqld_safe yang dijalankan tadi.

# /etc/init.d/mysql restart

restart mysql dan login dengan password yang baru.

sekian dari saya, terimakasih. :)
Reply
Find Posts
Administrator
Administrators
Posts:
24
Joined:
Mar 2016
Likes:
0
Reputation:
0
2 Year Of Member
#2
Posted: 04-06-2016, 01:24 PM
Syedap tutorialnya
BackBox Linux Karawang Team || K-Secure
Reply
Find Posts
Legion
Legion
Posts:
12
Joined:
Mar 2016
Likes:
0
Reputation:
0
2 Year Of Member
#3
Posted: 04-06-2016, 01:42 PM
ini tutor sering banget ane lupa.. XD
Reply
Find Posts
Administrator
Administrators
Posts:
35
Joined:
Mar 2016
Likes:
0
Reputation:
0
2 Year Of Member
#4
Posted: 04-06-2016, 10:20 PM
ane mengalami error ni om "mysqld_safe A mysqld process already exists" setelah melakukan command melewati user privileges jadi ga bisa masuk ke akses mysql.
Harta, Tahta, Pevita
Reply
Find Posts
Junior Member
Posts:
10
Joined:
Mar 2016
Likes:
0
Reputation:
0
2 Year Of Member
#5
OP
Posted: 04-11-2016, 03:20 AM
(04-06-2016, 10:20 PM)Paradise Wrote: ane mengalami error ni om "mysqld_safe A mysqld process already exists" setelah melakukan command melewati user privileges jadi ga bisa masuk ke akses mysql.

mysql nya udah di stop ?
Reply
Find Posts
Administrator
Administrators
Posts:
35
Joined:
Mar 2016
Likes:
0
Reputation:
0
2 Year Of Member
#6
Posted: 05-15-2016, 07:07 AM
(04-11-2016, 03:20 AM)tyo Wrote:
(04-06-2016, 10:20 PM)Paradise Wrote: ane mengalami error ni om "mysqld_safe A mysqld process already exists" setelah melakukan command melewati user privileges jadi ga bisa masuk ke akses mysql.

mysql nya udah di stop ?

oke bro nanti ane coba
Harta, Tahta, Pevita
Reply
Find Posts
Register an account or login to reply
Create an account
Create a free account today and start posting right away. It only takes a few seconds.
Login
Log into an existing account.
1 Guest(s)