You can use the "forgot my password" link and put in your email address. If that's not working then in a PHP script or on the command line run this:
echo password_hash("password", PASSWORD_DEFAULT);
Replace "password" with the actual password you want to use. You'll get a string that starts "$2y$10...", copy that into the 'passhash' field of the users table for that user.