Adding a new user directly in database I've been given the files to a Drupal site so I can create a new theme. I haven't, however, been given the Drupal admin user/password date so I can't sign in to the admin area. Is there a way I can create a new user directly in the database or some other way?
There's a much easier way.


Go into the DB and change the email address field of the user with id 1 and set it to your email address.
Go to http://mysite/user and click on the password recovery link.
Enter your email address and you'll get a password recovery link.


Of course this assumes that your dev systems allows drupal to send mails out of the box. This is true for most linux and osx boxes but not for Windows.