<p>There are so many tables that phpMyAdmin paginates them. All the tables that came after craft_tags alphabetically are on the second page, making it look like there is no craft_users table. Pagination controls are at the top:</p>

<p><a href="https://i.sstatic.net/9QxUE.png" rel="noreferrer"><img src="https://i.sstatic.net/9QxUE.png" alt="craft_users is on the second page"></a></p>

<p>Reason I know? I just made the same mistake.</p>

CC BY-SA 4.0
2024-01-17T23:31:56.660Z
You saved my day! PMA UX is horrible! Although, resetting users can **now** be done with the [craft console](https://craftcms.com/docs/4.x/console-commands.html#users-set-password) easily
Christian Ulbrich
CC BY-SA 4.0
2019-01-09T14:50:28.837Z
2019-01-09T14:50:28.837Z
Ian Gibbs
<p>A Craft website can be configured to have a different table prefix. This can be updated in the <code>craft/config/db.php</code> file:</p>

<p>In this example, the prefix is the default, <code>craft</code>, so the users table will be <code>craft_users</code></p>

<pre><code>return array(
    '*' =&gt; array(
        'tablePrefix' =&gt; 'craft',
    )
);
</code></pre>

<p>In this example, the prefix is <code>unexpected</code> so the users table will be <code>unexpected_users</code></p>

<pre><code>return array(
    '*' =&gt; array(
        'tablePrefix' =&gt; 'unexpected',
    )
);
</code></pre>

<p>In this example, the prefix is (blank) so the users table will be <code>users</code></p>

<pre><code>return array(
    '*' =&gt; array(
        'tablePrefix' =&gt; '',
    )
);
</code></pre>

CC BY-SA 3.0
2017-10-19T14:09:41.663Z
Hi thanks for the quick response.  The database is using craft_  as the prefix.  There is just no  users table there at all. ive clicked into each table in phpmyadmin and none seem to be a users one.  Is it possible to have users on the dev site, but launch the finished site without user access, either for security or so that only the dev team can alter?
springboynick
CC BY-SA 3.0
2017-10-19T14:36:25.697Z
The db.php file will also probably show you the name and connection info of the DB Craft is connecting to. Maybe the one you are looking for is in a different location? I don't believe Craft support s have some DB tables in other places
Ben Parizek
CC BY-SA 3.0
2017-10-19T15:01:51.363Z
Db.php confirms that the database it is connecting to is the correct one im looking at.  Id just doesnt have a users table.  If I were to create one, would this work?
springboynick
CC BY-SA 3.0
2017-10-19T15:45:26.473Z
If there isn't a `users` table then the Craft installation is broken and won't work anyway.
Brad Bell
CC BY-SA 3.0
2017-10-21T12:36:41.683Z
H Brad.  The webste s working in general.  But ive just set up a new test site and that doesnt have anythng in the users group table that relates to the admin user
springboynick
CC BY-SA 3.0
2017-10-19T12:50:31.623Z
2017-10-19T12:50:31.623Z
Ben Parizek
<p>Good Afternoon.</p>

<p>Im trying to recover admin login information for a website I have recently taken on, however there is no craft_users table within the database.  Any help to locate the user info would be greatly appreciated.</p>

<login>
No craft_users table in Database
# No craft_users table in Database

(Asked by: username_0 on 2017-10-19)

Good Afternoon.

Im trying to recover admin login information for a website I have recently taken on, however there is no craft\_users table within the database. Any help to locate the user info would be greatly appreciated.

**Tags:** login

---

## 2 answers

### Answer by username_1 on 2019-01-09. Score: 5

There are so many tables that phpMyAdmin paginates them. All the tables that came after craft\_tags alphabetically are on the second page, making it look like there is no craft\_users table. Pagination controls are at the top:

[![craft_users is on the second page](https://i.sstatic.net/9QxUE.png)](https://i.sstatic.net/9QxUE.png)

Reason I know? I just made the same mistake.

> **Comments:**
> **username_2**: You saved my day! PMA UX is horrible! Although, resetting users can **now** be done with the [craft console](https://craftcms.com/docs/4.x/console-commands.html#users-set-password) easily  

---

### Answer by username_3 on 2017-10-19. Score: 2

A Craft website can be configured to have a different table prefix. This can be updated in the craft/config/db.php file:
In this example, the prefix is the default, craft, so the users table will be craft_users
return array(
    '*' => array(
        'tablePrefix' => 'craft',
    )
);

In this example, the prefix is unexpected so the users table will be unexpected_users
return array(
    '*' => array(
        'tablePrefix' => 'unexpected',
    )
);

In this example, the prefix is (blank) so the users table will be users
return array(
    '*' => array(
        'tablePrefix' => '',
    )
);

> **Comments:**
> **username_0**: Hi thanks for the quick response.  The database is using craft_  as the prefix.  There is just no  users table there at all. ive clicked into each table in phpmyadmin and none seem to be a users one.  Is it possible to have users on the dev site, but launch the finished site without user access, either for security or so that only the dev team can alter?  
> **username_3**: The db.php file will also probably show you the name and connection info of the DB Craft is connecting to. Maybe the one you are looking for is in a different location? I don't believe Craft support s have some DB tables in other places  
> **username_0**: Db.php confirms that the database it is connecting to is the correct one im looking at.  Id just doesnt have a users table.  If I were to create one, would this work?  
> **username_4**: If there isn't a `users` table then the Craft installation is broken and won't work anyway.  
> **username_0**: H Brad.  The webste s working in general.  But ive just set up a new test site and that doesnt have anythng in the users group table that relates to the admin user  

---

