Knowledgebase

If you have forgotten your administrative password and want to recover it, you can use the "password recover mechanism" available under your Gallery’s login page.

Please note, that you must have access to the email address, which you have provided as an administrative one during the installation process or which you have set later through the administrative area.

In case you do not have access to that email address, you can set new one directly through the database related to the Gallery2 website. You can use the following instructions to access it and make the necessary changes:

Access your cPanel -> Databases section and click phpMyAdmin. Once phpMyAdmin loads select the Gallery2 database* from the drop-down menu to the left. The page will refresh and the database’s tables will be displayed. Open the SQL tab (look at the top navigation bar).

In the text field write the following SQL query:

[sourcecode language="php"]
UPDATE g2_User SET g_email = ‘new_email’ WHERE g2_User.g_userName = ‘admin_username’ LIMIT 1 ;
[/sourcecode]

Change "new_email" with the email address you wish the new password to be sent to and "admin_username" with your Gallery2 administrative username. Bear also in mind that the g2_ prefix may differ for your database. You can see the correct prefix after selecting the Gallery 2 database inside the phpMyAdmin tool.

Once you are ready, click on the GO button to submit the query. If everything goes fine without errors, go to your Gallery2 login page and try again to retrieve your administrative password.

* If you have more that one database inside the phpMyAdmin tool you can check the configuration file of the Gallery2 application called config.php (situated in the Gallery 2 installation/root folder) to find the correct one. The line which you need to look for inside is:

[sourcecode language="php"]
$storeConfig['database'] = 'name_of_the_database';
[/sourcecode]

You can open the file using the Code Editor in your cPanel’s File Manager.