# Forgot Username

**URL:** <https://community.open-emr.org/t/forgot-username/24216>\
**Category:** Management and Administration\
**Tags:** question\
**Created:** [January 5, 2025, 2:16pm UTC](https://community.open-emr.org/t/forgot-username/24216 "2025-01-05T14:16:42Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![remyrz](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@remyrz](https://community.open-emr.org/u/remyrz)\
**Post date:** [January 5, 2025, 2:16pm UTC](https://community.open-emr.org/t/forgot-username/24216/1 "2025-01-05T14:16:42Z")

</div>

Someone told me about OPENEMR and guided me through installing it, but I forgot to write the username. Is there a way to retrieve it somewhere?

---

<div class="post-metadata">

**Author:** ![sjpadgett](https://community.open-emr.org/user_avatar/community.open-emr.org/sjpadgett/32/21623_2.png) [@sjpadgett](https://community.open-emr.org/u/sjpadgett)\
**Post date:** [January 5, 2025, 3:14pm UTC](https://community.open-emr.org/t/forgot-username/24216/2 "2025-01-05T15:14:42Z")

</div>

Look in users table to see user names but not password.

---

<div class="post-metadata">

**Author:** ![remyrz](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@remyrz](https://community.open-emr.org/u/remyrz)\
**Post date:** [January 5, 2025, 3:32pm UTC](https://community.open-emr.org/t/forgot-username/24216/3 "2025-01-05T15:32:26Z")

</div>

thank you, where is that exactly? yes I do remember the password

---

<div class="post-metadata">

**Author:** ![ruth](https://community.open-emr.org/user_avatar/community.open-emr.org/ruth/32/19367_2.png) [@ruth](https://community.open-emr.org/u/ruth)\
**Post date:** [January 5, 2025, 4:04pm UTC](https://community.open-emr.org/t/forgot-username/24216/4 "2025-01-05T16:04:01Z")

</div>

hi remy,  
and welcome to the openemr community.

i think jerry was referring to drop down menu admin-\>users - clicking on a user lets you change their password.

one can also look in the ‘user’ table of the database - but as jerry says, one can’t see passwords as they are stored encrypted in a different table ‘users\_secure’

---

<div class="post-metadata">

**Author:** ![remyrz](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@remyrz](https://community.open-emr.org/u/remyrz)\
**Post date:** [January 5, 2025, 6:06pm UTC](https://community.open-emr.org/t/forgot-username/24216/5 "2025-01-05T18:06:05Z")

</div>

I understand, im stuck here

 ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/e/3/e3eee0aa6cf4d03602effda11837ef7817d0f60a.png)

so if in the database I can see the username, ill be good because I remember the password. where I can find what you say?

---

<div class="post-metadata">

**Author:** ![alfa](https://community.open-emr.org/user_avatar/community.open-emr.org/alfa/32/21202_2.png) [@alfa](https://community.open-emr.org/u/alfa)\
**Post date:** [January 5, 2025, 6:30pm UTC](https://community.open-emr.org/t/forgot-username/24216/6 "2025-01-05T18:30:38Z")

</div>

You may do this (examples are in Windows environment, adjust accordingly):

- Find your SQL configuration of your openemr folder on disk (e.g: _C:\xampp\htdocs\openemr\sites\default\sqlconf.php_)
- Record/memorize the user and password from the file above (might be simply _openemr for both user and password_ in case left to defaults)
- Find MySQL client folder and change directory to that from command line (e.g: _cd /d C:\xampp\mysql\bin_)
- Run mysql -u openemr -popenemr openemr (first openemr is username, next that is attached to p is password and the last is database name in this case, adjust if necessary)
- now execute “SELECT \* from users\_secure;” in the client command line interface  
 ![USer](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/3X/2/d/2d044c6e4f426ef779ebf93c71072295a9d66eab.png)

---

<div class="post-metadata">

**Author:** ![remyrz](https://community.open-emr.org/letter_avatar_proxy/v4/letter/r/e9a140/32.png) [@remyrz](https://community.open-emr.org/u/remyrz)\
**Post date:** [January 5, 2025, 6:53pm UTC](https://community.open-emr.org/t/forgot-username/24216/7 "2025-01-05T18:53:49Z")

</div>

> [@alfa](#):
>
> SELECT \* from users\_secure;

got it! thank you very much to you and everyone who reply so quick! 😃

---

<div class="post-metadata">

**Author:** ![ruth](https://community.open-emr.org/user_avatar/community.open-emr.org/ruth/32/19367_2.png) [@ruth](https://community.open-emr.org/u/ruth)\
**Post date:** [January 5, 2025, 7:15pm UTC](https://community.open-emr.org/t/forgot-username/24216/8 "2025-01-05T19:15:13Z")

</div>

can select from “users” table as well - the table has all the user names.

when i set up my test system it automatically had ‘admin’ with password ‘pass’ to start with - might your system have that ?

and if you can log in as admin you can see the other users from the admin-\>users menu