deleted my admin account on accident... Help

I logged in as admin and was deleting the guest shopping carts and I accidentially deleted my admin account. Now i cannot log in.
How do i recover it, or how do i set up a new admin account so i can continue to build the site?
Can I change it back once I get access to the admin backend?
All help is appreciated.

ok, fixed it. I will post the fix here.
If anyone wants to recover there deleted admin account. Run this query on the database.

UPDATE Customer SET Deleted = 0 WHERE (Email = 'your email address')

This fixed it for me

It all sounds so simply. My problem is connecting to the database. I'm running nopCommerce on a virtual Windows 7 machine. I don't not know how to connect to the database in this instance. If anyone could point me in the right direction it would truly be appreciated. SP

SPeruch wrote:

Hi, first of all you need to have installed SQL Server Management Studio (not SQL Server, but SQL Server Management Studio)... that's an application that you use to connect to your database.

Then you need to get your connection details, which you can find by going to your nopCommerce installation folder, and open the file: ...\App_Data\Settings.txt. If you're not sure how to read a connection string, then google it - you should find it quite easily.


As for SQL Server Management Studio, you can download the Express version from the Microsoft website (https://msdn.microsoft.com/en-us/library/mt238290.aspx). It's Express, so it has limitations in terms of licensing, usage & what it can do... but it can do what you need so it's good.


Hope this helps

Thank You nop-payments, that was what I needed to get that account up and running. I appreciate it. SP

i accedentally remove my admin account on nopcommerce, now i've alrady read all the things to do.. how can i access my data base? to make a new admin user in my website? hope to have an answer asap ;(((

i accedentally remove my admin account on nopcommerce, now i've alrady read all the things to do.. how can i access my data base? to make a new admin user in my website? hope to have an answer asap ;(((

123456abc wrote:


If you use shared hosting ..contact to the hosting provider to get db access.

sohel wrote:

thanks for the response.. i have an access to the shared hosting the problem is.. i dont know how to download the database it self

how do i access the SQL?