Add admin opencart Via Mysql

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