Add admin opencart Via Mysql

Menambahkan admin user Opencart melalui Mysql,sebenaranya ini solusi ketika ane mau masuk ke admin web opencart klien ane.Tapi waduh username dan pass admin kok ya tidak dikasih.padahal minta beneriin ini itu,nunggu email balesannya kelamaan jiah...malah curhat ane :D

Langsung aja ane buka Cpanel webnya buat nambahin admin baru tanpa sepengetahuannya hehe dan tentunya tanpa mengubah password admin punya dia.

Berikut ini caranya,silakan disimak :

1.Jika ente sudah login ke cpanel web cari folder "phpMyAdmin" dan klik aja

2.Setelah masuk ke phpMyAdmin klik nama sql yang ente gunakan.(list nama sql ada di samping kiri)

3.Selanjutnya buka ab "SQL" seperti gambar dibawah ini 

4.masukan kode dibawah ini di kolom SQL query (lihat gambar diatas)

INSERT INTO oc_user VALUES
(9999,1, 'admin123', '21232f297a57a5a743894a0e4a801fc3', '',
'firstname', 'lastname', 'email@example.com', '',
'0.0.0.0',1,CURDATE());

5.Ganti nama firstname, lastname,dan email dengan nama dan email ente (text ane beri warna merah)

6.Jika sudah Klik tombol "Go"

7.Done admin baru udah ente tambahkan

8.Selanjutnya jika ingin masuk ke admin ente harus ganti password dulu ,karena diatas tadi ente kan kagak tau passnya hehe.Masuk ke list tables Oc_user dan pilih "admin123"yang telah dibuat tadi klik edit

9.Ganti passwordnya dan kolom "Varchar(40)" ente pilih MD5 (lihat gambar dibawah)

10. Klik save/simpan

11.Done ,silakan ente masuk admin web opencart dengan username dan passoword admin yang ente buat tadi

English Language

Adding a user admin OpenCart through Mysql, this is actually the solution when I want to enter a web admin OpenCart my client .But admin username and pass not given.LOL

Immediately wrote i open its Cpanel create a new admin . hehe without her knowledge and certainly without changing the admin password got him.

Here's how, please observe:

1. If ente already logged into cpanel web search folder "phpMyAdmin" and click

2. After entry into phpMyAdmin click the name of the  sql you use. (Sql name list on the left side)

3.Next, open Tab "SQL" as shown below

4.Input code below in the column SQL query (see picture above)

INSERT INTO oc_user VALUES
(9999,1, 'admin123', '21232f297a57a5a743894a0e4a801fc3', '',
'firstname', 'lastname', 'email@example.com', '',
'0.0.0.0',1,CURDATE());

5.Change name firstname, lastname, and email with your name and email ( red color text)

6. If already Click button"Go"

7.Done you already add new admin

8.Next if it wants to enter the admin password you must change first..Entry Oc_user tables to list and select "admin123" that was created earlier click edit

9.Change password and column "Varchar (40)" select MD5 (see picture below)

10. Click save button

11.Done, please incoming yours web admin OpenCart with the admin username and password created earlier

Posted by Numpak Gundam

Tweet