Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-01-17T23:31:56.660Z
Answers.Text: 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
Answers.UserDisplayName: Christian Ulbrich
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-09T14:50:28.837Z
Answers.LastActivityDate: 2019-01-09T14:50:28.837Z
Answers.UserDisplayName: Ian Gibbs
Answers.Body: <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>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T14:09:41.663Z
Answers.Text: 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?
Answers.UserDisplayName: springboynick
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T14:36:25.697Z
Answers.Text: 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
Answers.UserDisplayName: Ben Parizek
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T15:01:51.363Z
Answers.Text: 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?
Answers.UserDisplayName: springboynick
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T15:45:26.473Z
Answers.Text: If there isn't a `users` table then the Craft installation is broken and won't work anyway.
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-21T12:36:41.683Z
Answers.Text: 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
Answers.UserDisplayName: springboynick
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-19T12:50:31.623Z
Answers.LastActivityDate: 2017-10-19T12:50:31.623Z
Answers.UserDisplayName: Ben Parizek
Body: <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>
  
Tags: <login>
Title: No craft_users table in Database
ThreadText: # 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 username_4.  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  
  
  ---
  
  