Errors 

I forgot my admin password. Recovering the admin password using phpMyAdmin. And finally, in my opinion, the easiest and fastest option for restoring the login to the opencart admin panel

From the author: Greetings, friends. From this article you will learn how to recover your DLE admin password. This topic is relevant for any site on any engine, since it is common for any person to make mistakes, and anyone can forget the password for the admin panel. So let's see how to recover your DLE password.

Let's start with the fact that password recovery may be relevant not only for the site administrator, but also for ordinary site visitors on DLE. This is logical, since each of us can forget the password, just like the administrator.

The password recovery procedure for ordinary users is quite simple. At the top of your site, find a login link and usually somewhere nearby there may be a link to a password recovery page. In standard DLE template it looks like this:

If your template doesn't have anything similar, then just use the link the following type— http://your_domain/index.php?do=lostpassword

The link takes us to the password recovery page, where you just need to enter your login or email to start the password recovery procedure. After this, you will receive instructions on how to reset your password by email.

However, all this by default only works for ordinary users. When attempting to recover a password, the administrator will see the following message:

It turns out that by default, administrator password recovery is disabled for security reasons. If you want to enable the password recovery function for administrators in the future, you can do this in the admin panel in the Users - User Groups Settings menu. In the table, select the Administrators group and from the Action list select Edit.

On the group settings page, enable password recovery.

But all this is possible, of course, only if you have not forgotten the password to the DLE admin panel and have access to it. But what should an administrator do if he has forgotten his password and does not have access to the admin panel? Is everything really lost?

No, don't rush to panic. There is another option for changing the password. For this option, you will need access to the site's database. As you probably already guessed, we will execute an sql query with which we will simply change the administrator password in the corresponding table. The request will look like this:

Here we update the dle_users table. Check what your table name is, because if you changed the table prefix during the installation phase, then a different prefix may be specified instead of dle_. In this case, indicate it. Next, in this part - MD5(MD5('111111′)) - the password 111111 is set as the new password. Accordingly, you can set your own. Well, the last part of the query - WHERE name = 'admin' - indicates the user name. Here, accordingly, you will indicate your administrator login.

That's all for me today. If you want to get to know DLE better and learn how to create your websites from scratch using this CMS, then check out our course. Good luck!

...everything is simple, although the procedure for recovering a site password on MaxSitecms is different and a little more complicated than the mechanics, but this is rather a plus... ...because the enemy’s selection of keys to the admin panel of a site on MaxSiteCMS becomes advantageously more complicated.

Anyone who has encountered the problem of “forgetting a password” knows!

Recovering a site password in the MySQL MaxSite CMS database

that you (as an admin) cannot do this through the password recovery page for KOMUSERS - you can log into the admin area, but you can’t recover your password! No input Email won't help you. Therefore, we need access to the site's Database control panel. So:

...go to the database. On the left in the menu we find the line mso_users (click) –

we will be redirected to the editorial page of the site admin and authors tables. Now a moment of attention: but even in the MySQL Database we cannot easily replace our password, let’s say, as this can be easily implemented with sites on engines like Joomla or WordPress (WoldPress). Let me explain a little to make everything clear:

All passwords are stored in the database in encrypted form (pay attention to the parameters, namely what is written below users_password - a string of characters -

Photos — 2

this is your encrypted password hash. Remember this window - we will need it soon. So, as you understand, all passwords are stored in the database in encrypted form, and the encryption of passwords by the system is generated using the position MD5.

...first, in the drop-down window (underlined in green) select MD5 and - (underlined in brown) register New Password ordinary characters. Click “OK” at the bottom of the page. That's it, your new password is encrypted and is now displayed in the “parameters” photo 2

But, unfortunately or NOT UNFORTUNATELY, this method will not work for us either. And good! ...because the evil one, having taken possession of the password from your Database, will not be able to easily change your ADMINISTRATIVE password, because it does not know your “secret word or phrase”, remember, which you wrote down during the initial installation of your site on MaxSite, in the mso_config.php document. The way is:

DOMEN.ru/application/maxsite

(replace with your website domain).

...the secret phrase will be useful to us!

Here we come to the most important moment - restoration forgotten password blog on MaxSitesms:

Come in file manager and create a document in the root of your site with absolutely any name (English characters), but with the extension .php I called j.php

Open it for editing... and write the following line in it:

As you understand, the first numbers in quotes are your new password and...your secret phrase. You write all this in a line... Save! And open the created document in the browser. Enter the following address into the browser window and press “Enter”:

http://DOMEN.ru/j.php

This will be your new encrypted password (hash).

Copy it to the clipboard. I think it’s not worth saying that it needs to be entered in the field shown in photo 2.

This is done like this:

Go to “Options” again. Now you don’t need to click the “Change” link, but just double-click directly on the hash line that is underlined. A quick “edit” will open; enter your copied encrypted password in this window.

Click "OK".

That's it, the new password has been set. Thus, our password was generated not just using MD5, but also, so to speak, additionally checking/confirming your RIGHTS to CHANGE the password - using a secret phrase (key). Extra protection!

Check your admin login.

As for the created document, you can delete it, for good measure... or save it somewhere on your computer.

Now you know how passwords are recovered in CMS MaxSite and WordPress

Thanks for pressing the buttons))

Restoring access to the site

Some time ago I wrote about Image CMS and announced a post in which I was going to talk in detail about creating a website using this engine. I created the website, but only half wrote the article. This happened due to the loss of the password for the site admin panel (for Image CMS, password recovery via email works, to put it mildly, through one place: /auth/login). The password disappeared somewhere in the depths of two computers, a couple of flash drives, an external screw and a giant archive in a Google Doc. In principle, the site could be reinstalled in 5 minutes, but you know - laziness. As a result, I decided to change the password immediately in mysql database. Today's post will be about how to recover a website password, having only access to hosting at hand. Let me complicate the situation a little: imagine that you have lost the password not only for the site admin area, but also for the mysql database itself. I’ll look at examples of popular CMS: WordPress, Joomla!, DLE, and Image CMS itself.

The password for the site admin is written in the database, so first of all you need to gain access to it.

Restoring access to the mysql database

The engine files are connected to the database using a configuration file, which contains the necessary information: Database user name, Database name, Password, encoding, host, table prefixes, etc. We need to find this file among the files of our CMS. Where to look for it?

WordPress/wp-config.php (site root)

Joomla!/configuration.php (site root)

DLE/engine/data/dbconfig.php

Image CMS/application/config/config.php

So, we found and opened the configuration file (either using the hosting interface, or by downloading it to a computer using any text editor). The following lines are of interest:

For WordPress

For Joomla!

For DLE

For Image CMS

That is, we need: database name, username and password. The name of the database is needed if we have many databases on our hosting with intricate names and we don’t know which one belongs to the desired site. Having found the desired database, we go into it in the phpMyAdmin interface (available on almost every hosting). When logging into phpMyAdmin, we use the login (Username) and password (Database Password) taken from the configuration file.

All access to mysql has been restored, now it’s time to work on the password for our site. (all pictures are clickable)

So, we see the tables that make up our database. We are looking for a sign that is responsible for site users (users or something similar). For announced CMS these will be:

WordPress

wp_users (table) - user_pass (field)

jos_users (table) - password (field)

dle_users (table) - password (field)

Image CMS

users (table) – password (field)

Once you have found the table you need, select it and go to the “Browse” tab.

Click " Change"(pencil icon) after which we change the value of the password field to our new password. Now it is mandatory in the column “ Functions» set the MD5 value (as shown in the figure). MD5 is a password hashing (encoding) algorithm. Now click " OK" Ready.

So in 2-3 minutes we completely restored access to the site: first we received the password to the database, then to the admin panel itself. While I was writing this post, I changed passwords this way on several sites and found a lot of information on the Internet on the topic of changing passwords. Later I will share with you the most interesting things.

Don’t forget or lose your passwords so you don’t have to worry about recovering them later.

Thank you for your attention!

From Joomla! Documentation

This article is for Joomla! CMS Version(s)

Typically, you can add, change and delete users and passwords in the user manager of the administrative panel. To do this, you must enter [your account] as a member of the super admin group.

In some situations this is not possible. For example, [when] your website was hacked and the password or users were changed. Or perhaps the person who knew the passwords is no longer [working with this site]. Or maybe you forgot the password you used.

In such cases, it is still possible to change the Joomla! database so that you can still log in to the site again as a super administrator. Below are the methods available for this for Joomla! Super Administrators.

Contents

First method: configuration.php file

If on your web server you have access to your configuration.php file of your Joomla! installation, then you can recover your password using the following method.

1. Using any FTP client, connect to your website. Find your configuration.php file and look at the permissions on it. If its permissions [shown as] 444 or some other value, then change them to 644. This will help avoid problems loading the modified configuration.php file later in the process.

2. Download this configuration file.

3. Open this downloaded configuration.php file in some text editor, such as Notepad++, and add the following line [to it]

Public $root_user="myname";

at the bottom of the list, where "myname" is the name of the user with administrative access for which you know the password. A username with administrative access can be replaced by a username with "Author" level or higher.

4. Save this configuration.php file and upload it back to your website. You can leave its rights [at value] 644.

This user will now be a temporary super administrator.

5. Log into [your] admin panel and change the password of the admin user whose password was lost, or create a new user with super admin rights. If you create any new user, then, depending on your circumstances, you can either block or delete that old user.

6. When you're done, make sure you use the "Click here to try to do it automatically" link that appears inside the warning block to remove it from your configuration.php file. line. If you didn’t succeed in using the link, then go back and use a text editor to delete the line added to the configuration.php file. Upload the configuration.php file back to your website.

7. With your help FTP programs Make sure that the permissions on the configuration.php file [are] 444. If you removed that added line manually, then change the permissions to 444.

If you do not have users who know their password and you cannot enable registration from the front web pages, then you may need to make a change to your database as outlined in this document below.

Second method: directly changing the database

If the above methods do not bring results, then you have two choices, both of which require working with the database MySQL data directly.

Changing the password in the database

If administrative user is still determined, then in a simple way is to change his password in the database to some known value. This requires that you have a password to the MySQL database using phpMyAdmin or some other client.

Once you have regained access, make sure you change [this] password

These instructions show how to manually change the password to the word - "secret"

  1. Go to phpMyAdmin and in the [databases] drop-down list on the left, select this website's Joomla! The tables of this database will appear on the left side of the screen.
  2. Find a table called "_users" (note: in this name you will have your own value before the bottom line).
  3. Click on the "Browse" button on the toolbar. This will show all users configured for this website.
  4. Find the user whose password you want to change and click on the "Edit" button in this row.
  5. [In response to you], a web form will open that will allow you to change [value] in the password field. Copy the value below

    : trd7TvKHx6dMeoMmBVxYmg0vuXEA4199

    Enter this password field and click on the "Go" button. phpMyAdmin should [response] show the message "Affected rows: 1". At this point the password should change to "secret".

  6. Login as this user and change this password to something secure. Check all users in the user manager and make sure that all of them [were actually created by you]. If your [site] has been hacked, you may want to change all passwords on that site.

Add new user as super admin

If changing the password does not work, or if you are not sure which user is a member of the super administrators group, then you can use this method to create some new user.

  1. Go to phpMyAdmin and select [your] Joomla! website database from the list on the left. This will show the tables in that database on the left side of this screen.
  2. Click on the "SQL" button on the toolbar to execute some data in this database. SQL query. This will show a field called "Run SQL query/queries on database<название Вашей базы данных>".
  3. Delete the text [in it] from this field, copy and paste the following query into it below and click on the “Go” button to execute this query and add a new administrative user to this table.
  4. Use the following SQL code to add another administrator account.

Make sure that the table prefix matches yours!

The following example code uses "jos31" as a database table prefix. This prefix will either be assigned randomly at your initial installing Joomla!, or you specifically assign it yourself. You need to change all references to the prefix found in the following code jos31 to the attachment used in your own installation.

SQL code for use with Joomla!

INSERT INTO ` jos31_users ` (` name ` , ` username ` , ` password ` , ` params ` , ` registerDate ` , ` lastvisitDate ` , ` lastResetTime ` ) VALUES ( "Administrator2" , "admin2" , "d2064d358136996bd22421584a7cb33e:trd7TvKHx6dMeoMmBVxYmg0vuXEA4199", "" , NOW (), NOW (), NOW ()); INSERT INTO ` jos31_user_usergroup_map ` ( ` user_id ` , ` group_id ` ) VALUES ( LAST_INSERT_ID (), " 8 " );

At this point you should be able to log into the Joomla! with username "admin2" and password "secret". Once logged into the admin panel, go to the user manager and change this password to a more secure value and add a valid email address to this account. If there is a possibility that you have been hacked, then check to see if there are any users created without your knowledge, especially in the super admin group.

Recently I decided to get into an abandoned project on a local server and realized with horror that my favorite admin password It doesn't roll at all. I had to rummage a little in the database, as a result of which this article was born.

A little theory

If your site is dynamic, then to fill the site you use CMS(content management system), is a program that provides tools for editing and managing content. And the information itself is stored in databases.

Many engines use the DBMS (database management system) MySQL. To make working with this system easier, there is phpMyAdmin - a web application with open source, written in PHP and is a web interface for administering the MySQL DBMS.

PhpMyAdmin allows you to administer the MySQL server through a browser, run SQL commands and view the contents of tables and databases.

It is this application that will help us recover the administrator password on the local server.

Recovering the site administrator password

1. Launch local server(let it be Denver).

2. To get to phpMyAdmin, you need to type http://localhost/Tools in the address bar.

4. We are trying to remember the name of the database of the site we need. If you showed miracles of ingenuity when creating the project, then the name of the database will coincide with the name of the site.

5. Select the base we need in the window on the left.

6.Look in the left column for the table where all user passwords are stored - jos_users and click. On the right we see the structure of the table.

7. In the top menu, click the “Browse” tab. We see a table with a list of all users, their logins and passwords.

And then you see that in the “password” field, instead of your beautiful password, some long and incomprehensible code is written. The fact is that all passwords in the database are encrypted using the MD5 procedure and decrypting them is quite difficult. All this is done to protect yourself from the dirty playful hands of others.

So you won’t be able to see your password explicitly, but we can replace it with a password code that we know.

8. Click on the picture with a pencil opposite Administrator, in the “Value” column of the “password” field, delete the encoded Old Password and insert the new code, for example, this is how the “admin” password is encrypted. You can take the code of another password you know from another site; to do this, you need to go to its database and copy the password code.

9.Save the changes. We go to the site’s admin panel using the login that is registered for the administrator in the jos_users table (fortunately, it is not encrypted there) and the password admin.

10. To celebrate, don’t forget to change the administrator password in the admin panel.

For those who are especially smart: click on “site” at the top, select the “users” tab, click on “administrator” and in the user data change the password to a new one.

People keep money in savings accounts and passwords and logins in a notepad in their desk.

And you will be happy!